How to Track Raw Materials and Supplies for a Handmade Business

Your materials are where most of your money sits and where most of your profit leaks. For many handmade products, materials are the single largest cost — often well over half. Yet most makers track supplies loosely: a guess at what's in the drawer, a vague memory of what they paid. This guide gives you a simple, reliable system for tracking raw materials so you never run out and never lose track of cost.

Track by usable unit, not by package

The most important habit: record each material in the unit you actually consume, not the package you buy it in.

Buying fragrance in 16 oz bottles but using it by the ounce? Track it in ounces. Buying yarn in skeins but using part of one per item? Track it in grams or meters. This matters for two reasons:

• Accurate stock: a recipe can consume part of a unit. "Half a skein" or "0.8 meters" becomes a real, countable quantity instead of a fuzzy guess.
• Accurate cost: your cost-per-usable-unit (e.g. $1.50 per ounce of fragrance) flows cleanly into each product's cost.

This single change fixes the most common material-tracking headache makers describe: not knowing whether they used half a unit or three-quarters, and having no idea what fraction of a package's cost belongs to one product.

Record what you paid — every time

Material prices drift. The price you paid six months ago isn't today's price. Each time you buy a material, log the quantity and the unit cost. The most accurate way to value your stock is weighted-average cost: each purchase blends into the existing stock to give one current average. That average is what should feed your product costs.

Tracking this by hand is tedious, which is why most makers' cost numbers are stale. (For the full picture of how this rolls up into product cost, see How to Calculate COGS.)

Set a reorder level for every key material

A reorder level is the quantity at which you should buy more. Set it high enough to cover your supplier's delivery time plus a small buffer, so a slow shipment never leaves you unable to finish a batch.

For example, if you use about 2 lbs of wax a week and your supplier takes a week to deliver, a reorder level of 4–5 lbs gives you a comfortable cushion. When wax drops to that level, it's time to buy — ideally before you feel the pinch, not after.

Account for waste and offcuts

Real production isn't perfectly efficient. You spill a little, you trim offcuts, a pour comes out short. For cut or measured materials especially (fabric, wire, ribbon, clay), add a small waste percentage to your recipe — say 5–10%. This makes your consumption and cost reflect what actually happens, not the theoretical minimum. Without it, you'll quietly run short and your costs will read lower than reality.

Connect materials to products with recipes

The payoff of good material tracking comes when each material is linked to the products that use it through a recipe (which materials, how much of each, per finished unit). Once that link exists:

• Making a batch automatically deducts the right materials.
• You can see how many units you can produce with current stock.
• A price change on one material instantly updates the cost of every product that uses it.

That last point is powerful: shared materials (one wax across 40 candle variants) mean a single purchase decision ripples across your whole catalog.

A lightweight setup that actually gets done

You don't need a warehouse system. A workable setup is: list each material with its usable unit, current stock, last cost, and a reorder level. Then log purchases as you make them and let your recipes deduct usage as you produce. Start from today's counts — there's no need to reconstruct the past.

Doing all of this in a spreadsheet is possible but fragile: fractional usage, weighted-average cost, automatic deduction, and reorder alerts are exactly the things spreadsheets handle badly. Mavenory is built around this material layer — it supports fractional and waste-adjusted usage, keeps weighted-average costs current, deducts materials automatically from your recipes, and tells you which supplies to reorder this week.

The takeaway

Track materials by the unit you actually use, log what you pay every time, set reorder levels with delivery time in mind, and account for waste. Link materials to products with recipes, and your supply tracking turns from a source of stress into the backbone of accurate costs and confident production.

Next, see how materials and finished goods fit together in Inventory Management for Etsy & Handmade Sellers.