Tracking materials for a handmade business
A maker holds two kinds of stock at once — the materials and the finished pieces — and they move together. That is the whole difficulty, and it is why generic stock advice does not quite fit. Here is what to track, how to link the two, and what you can safely ignore.
Count the materials, not the components of the materials
The first trap is counting too finely. A jeweller does not need to track solder by the gram or thread by the metre unless it is genuinely a thing that runs out and stops work. A good test: would running out of this halt a sale, and does it take more than a few days to replace? If yes, count it. If not, buy it in bulk and forget about it. This usually leaves a much shorter list than expected — for most makers, somewhere between ten and fifty lines. That list is worth keeping accurate. A list of three hundred is not, because you will not keep it.
Finished pieces are stock too
The pieces sitting in the box ready for the next fair are stock, and they need a count for exactly the same reason materials do: so you know what you can sell without making anything first. Where one-off pieces are concerned this gets awkward, and the honest answer is that a piece which will only ever exist once does not need inventory management — it needs a note of where it is. Reserve counting for the things you make repeatedly.
Linking one to the other
The link is the part that saves the hour a week. Record, once, what one finished piece is made of: this necklace takes one clasp and two lengths of chain. After that, selling one necklace should deduct the necklace, the clasp and the chain in a single action. Without that link, you are editing three rows by hand every time, which is the step that people quietly stop doing after a fortnight — and once it stops, the materials count silently drifts until the day you run out of clasps mid-order. This link is sometimes called a bill of materials, which makes it sound like factory software. It is a short list per product, and most makers can write theirs out in twenty minutes.
What about cost of goods sold?
Craft inventory tools often lead with cost-of-goods-sold tracking: what each piece cost you in materials, carried through to tax reporting. It is genuinely useful at a certain scale, and reviewers of those tools say the same thing — powerful, thorough, and more than a small maker was looking for. If what you want is to stop running out of clasps, you do not need any of it. Unit cost is worth recording, because it turns a reorder list into a number you can decide about. Full COGS accounting is a bookkeeping job, and it can stay a bookkeeping job. The question worth asking of any tool: does it make the daily thing — counting — faster, or does it only make the yearly thing easier?
Fairs, markets and the count that comes back wrong
Selling in person is where counts drift furthest. You are busy, it is loud, and nobody is logging anything. Three things that help. Count out what you take, so you know the starting number. Log sales as they happen if you possibly can — one tap per item is realistic at a stall, opening a spreadsheet is not. And count back in on the same evening rather than the following week, while you can still remember the piece somebody bought while your card reader was misbehaving. Whatever the method, the count that matters is the one taken when the stock comes home.
Frequently asked questions
Do I need inventory software as a hobby-scale maker?
Probably not. A written list works while you can hold the whole thing in your head. The point where it stops is usually when you start making the same piece repeatedly and its materials become a supply chain rather than a shopping trip.
How do I track materials I buy by length or weight?
Pick the unit you buy in and stick to it — metres of chain, grams of clay — and record how much one finished piece consumes in that same unit. Mixing units between purchase and consumption is the most common source of a count that will not reconcile.
What about materials used in samples and mistakes?
Record them as stock leaving, the same as a sale. They consumed real material, and leaving them out makes your usage average too low, which makes your reorder point too low, which is how you run out.
Should finished pieces carry the materials cost?
For deciding what to reorder, no — it is enough to know what each material costs and how many you need. Costing a finished piece is worth doing before you set a price, but it is a different task and does not have to live in the same place.
More guides
Other things we made
Also in English, made by the same people.
Also in English, made by the same people.
Also in English, made by the same people.
Also in English, made by the same people.