Jewelry Inventory Management: How to Track and Organize (Free Spreadsheet)

If you run a small jewelry (or jewellery) business, your inventory is simultaneously your biggest asset and your biggest headache.

Wire, findings, gemstones, chain, clasps — the materials list is long before you even factor in your finished pieces, packaging, and samples. And that’s before you start selling across Etsy, your own website, and weekend markets. (The Etsy Seller Handbook covers the basics of listing and managing shop stock, but doesn’t get into materials-level tracking — which is exactly the gap this guide fills.)

Without a real system, things go sideways fast: you oversell a piece, run out of 4mm seed beads mid-order, or discover you’ve been pricing a best-seller below cost for six months because you forgot to account for the silver jump rings.

This guide covers exactly how to set up jewelry inventory management that actually works — including a step-by-step tracking method, a free spreadsheet template, and when it makes sense to move to dedicated software.

Last updated: March 2026

Why jewelry inventory management is different from other product businesses

Most inventory advice is written for businesses that buy finished goods and resell them. Jewelry making doesn’t work like that.

You’re a manufacturer. You buy raw materials — wire, stone, chain, findings — transform them into finished pieces, and sell the result. That means you need to track inventory at two levels: what goes in (materials) and what comes out (finished jewelry). The SBA’s guide to managing inventory outlines why this distinction matters for your business finances.

Miss either level and your numbers are wrong. You might know you have 200 finished earrings in stock but have no idea whether you have enough copper wire to make another 200. Or you track materials carefully but lose track of how much silver went into each pair — so your COGS is pure guesswork.

The other thing that makes jewelry tricky: materials are often sold in bulk and used in tiny quantities. A 100g spool of 0.8mm sterling wire might cost $45. Each bracelet uses roughly 18cm of it. The math isn’t hard, but doing it manually for every material in every product gets old fast.

Good jewelry inventory management solves for both problems: it tracks what you have on hand and links materials to the products they go into via a product recipe.

What counts as jewelry inventory?

Before building any system, it helps to be clear on what you’re actually tracking. Your jewelry inventory has three distinct layers:

Raw materials and components Everything you use to make jewelry: wire (sterling, gold-fill, copper, brass), sheet metal, chain, beads, cabochons, faceted stones, findings (clasps, jump rings, ear wires, bead caps), stringing materials (cord, thread, elastic), adhesives, and patinas.

Don’t forget consumables that get used up in production: liver of sulphur, pickle solution, polishing compounds, tumbler media. They’re not glamorous, but they’re costs.

Work in progress Pieces you’ve started but haven’t finished — a pendant at the soldering stage, a bracelet waiting to have the clasp added. WIP tracking is optional when you’re small, but useful once you have multiple products in production at once.

Finished goods Completed pieces ready for sale. If you sell the same design multiple times, each unit needs to be counted. If you make one-of-a-kind pieces, each piece is its own SKU.

Samples and display pieces These still cost materials to make, even if they’re not for sale. Track them the same way as finished goods — just flag them differently.

Packaging Boxes, bags, ribbon, tissue paper, thank-you cards, branded stickers. Easy to forget until you’re out at 11pm before a market.

How to track inventory for jewelry making — a step-by-step method

Whether you use a spreadsheet or software, the underlying method is the same. Here’s how to set it up properly.

Step 1 — Create a materials register

Start with every raw material you currently have in stock. For each one, record:

• A unique SKU or code (e.g., WIRE-SS-0.8MM for 0.8mm sterling silver wire) — our free SKU generator can help you create a consistent naming system
• Full description including specification (gauge, size, colour, supplier)
• Unit of measure (grams, metres, pieces)
• Current quantity on hand
• Unit cost (what you paid per gram/metre/piece)
• Reorder point — the quantity at which you need to order more
• Supplier name

The unit of measure matters. If you buy wire by the gram but use it by the centimetre, you’ll need a conversion factor. Decide upfront and be consistent — mixing grams and troy ounces for the same material creates errors that compound over time.

Step 2 — Build your product recipes (bill of materials)

This is the step most jewelry makers skip, and it’s the most valuable one.

For each finished product you make, write down exactly what materials go into it and how much. In manufacturing, this is called a bill of materials — but you don’t need to call it anything fancy. A simple table works fine:

Once you have recipes, you can do two powerful things: calculate your true cost per product (essential for pricing your handmade goods), and work backwards from a sales order to see whether you have enough materials on hand.

Step 3 — Record every stock movement

Inventory only stays accurate if you record every change:

• Materials in: when you receive a supplier order, add the quantities
• Materials out: when you make a batch of products, deduct the materials used
• Finished goods in: when you complete a production run, add to finished stock
• Finished goods out: when you make a sale, deduct from finished stock
• Adjustments: losses, breakage, quality failures, samples given away

This sounds like a lot, but in practice most jewelry makers only have a handful of movements per week. The discipline of recording them in the moment (not “later”) is what keeps the numbers trustworthy.

Step 4 — Set reorder points and low stock alerts

For each raw material, decide the minimum quantity you want on hand before you reorder. Factor in your typical lead time from suppliers — if your stone supplier takes three weeks to ship, you don’t want to hit zero and then wait.

A simple rule: reorder point = (average weekly usage × supplier lead time in weeks) + a small safety buffer. If you want to understand the true cost of running out, the stockout cost calculator can help you quantify it.

Write these reorder points into your tracking system. Then check the list weekly — anything below the line gets ordered.

Step 5 — Stocktake regularly

Physical counts catch the discrepancies that even a well-maintained system accumulates over time: a bead that rolled under the bench, a component used but not recorded, a package that arrived short.

How often depends on your volume. Most small jewelry businesses do a full stocktake once or twice a year, with cycle counts (counting one category at a time) monthly. The goal isn’t perfection on any single count — it’s catching drift before it compounds. See our introduction to stocktaking for a practical walk-through.

Using a spreadsheet to manage jewelry inventory

A spreadsheet is the right starting point for most jewelry makers. It costs nothing, works offline, and is flexible enough to adapt to how you actually work.

Set up separate sheets (tabs) for:

1. Materials — your materials register with current quantities
2. Products — your product list with SKUs and current finished stock
3. Recipes — bills of materials linking products to materials
4. Sales log — record of what sold and when
5. Supplier orders — incoming materials with dates and costs

The columns for your materials sheet should include at minimum: SKU, description, unit, quantity on hand, unit cost, total value, and reorder point.

Download our free jewelry inventory spreadsheet template to skip the setup and start tracking today. It includes pre-built sheets for materials, finished goods, and a basic recipe calculator.

What a spreadsheet can’t do well:

• Automatically deduct materials when you log a sale
• Alert you when stock drops below a reorder point
• Calculate COGS accurately across a mix of lot prices
• Sync with Etsy or Shopify so you’re not updating two places

These limitations aren’t deal-breakers when you’re small. But they become friction — and then errors — as your volume grows.

When to move beyond a spreadsheet

Spreadsheets break down at a predictable point: when the number of products × materials combinations gets large enough that manual recipe tracking becomes error-prone, or when you’re selling on multiple platforms and reconciling by hand.

Signs it’s time to look at dedicated jewelry inventory software:

• You have more than 20–30 active product SKUs
• You sell across more than one channel (Etsy + your website, or Etsy + markets)
• You’re spending more than an hour a week on inventory admin
• You’ve had a customer complaint because of an inventory error
• You can’t answer “am I making money on this piece?” without a spreadsheet calculation

Craftybase is built specifically for makers who manufacture their own products. It handles the materials-to-product recipe tracking automatically — so when a sale comes in, it deducts the right materials in the right quantities without you touching anything. It also connects with Etsy, Shopify, and WooCommerce so your finished goods inventory updates in real time.

For a full comparison of the options, see our best jewelry inventory software guide — we’ve tested and compared the top tools side by side.

How to organize your jewelry inventory day-to-day

Getting the system set up is half the battle. The other half is actually using it consistently. A few things that help:

Label everything with its SKU. When a material comes in from a supplier, label it before it goes on the shelf. The five seconds it takes saves ten minutes of hunting later.

Use consistent units. Pick one unit of measure per material and stick to it. Sterling wire gets tracked in grams, always. If your supplier invoice shows troy ounces, convert at entry time.

Batch your materials recording. Rather than recording every tiny movement in real time, many makers find it easier to do a “materials session” once a week — log all purchases that arrived, record all production batches completed. As long as you’re not selling out of materials, weekly works fine.

Store materials in a predictable place. If wire is always in the second drawer on the left, you’ll know immediately if something’s missing. Consistent physical organisation backs up your digital tracking.

Separate your samples. Display pieces and photography samples are still inventory — they have a cost. Keep them in a separate location and track them separately so they don’t get confused with sellable stock.

Jewelry inventory management and your financials

Your inventory tracking feeds directly into two numbers that matter for your business finances:

Cost of goods sold (COGS) — what it actually costs you in materials to make what you sell. This flows through to your profit and loss account. If your COGS tracking is wrong, your profitability numbers are wrong.

Inventory value — the total value of materials and finished goods you’re holding. This shows up on your balance sheet and affects your tax position at year end. The IRS requires you to use a consistent inventory accounting method (such as FIFO or average cost) — your choice here affects what your taxable income looks like, so it’s worth understanding before you scale.

Both numbers require the same thing: accurate per-unit material costs linked to accurate quantity records. This is the core reason jewelry makers who are serious about their finances eventually move beyond a spreadsheet — the COGS calculation specifically becomes very hard to maintain manually once you’re buying materials at different prices across multiple supplier orders.

For more on how inventory feeds into manufacturing financials, see our guide to manufacturing inventory management.

Common jewelry inventory mistakes (and how to avoid them)

Tracking finished goods but not materials. Knowing you have 15 earring pairs in stock is only half the picture. If you don’t know you’re also out of the ear wires to make more, you’ve got a production bottleneck you don’t see coming.

Forgetting packaging in your cost of goods. That branded box, tissue paper, and ribbon costs money. If it’s not in your recipe, your COGS is understated and your margins look better than they are.

Using the same spreadsheet for all versions of a product. A pendant in gold fill and the same pendant in sterling silver are two different products with different costs. Track them separately.

Letting stocktakes slip to annual-only. Annual stocktakes are fine for a business with slow-moving inventory. If you’re selling actively, waiting a year to reconcile means a year of compounding errors.

Not adjusting for waste. Wire cutting always generates offcuts. Some stones crack during setting. Build a small waste factor into your recipes rather than pretending every piece is made from exactly the planned quantity.

FAQ

What is jewelry inventory management? Jewelry inventory management is the process of tracking all materials, components, and finished pieces in your jewelry business — from raw materials like wire and findings through to completed products ready for sale. It includes recording what you have on hand, what goes into each product, and what’s sold.

How do you track inventory for jewelry making? Start by building a materials register — every wire, finding, stone, and component listed with a SKU, unit of measure, quantity on hand, and cost. Then write out a recipe (bill of materials) for each product you make, showing exactly what goes into it. Record every stock movement: materials in when you receive a supplier order, materials out and finished goods in when you complete a production batch, finished goods out when you make a sale. A free spreadsheet template handles this well when you’re starting out; dedicated software like Craftybase automates the deductions as you grow.

What should I track in a jewelry inventory spreadsheet? At minimum: material SKU, description, unit of measure, quantity on hand, unit cost, and reorder point. For finished goods: product SKU, description, quantity in stock, and production cost per unit. Linking materials to products via a recipe table is what makes the spreadsheet truly useful for cost tracking.

How do I organize my jewelry inventory? Label every material with its SKU before it goes on the shelf. Use consistent units per material — pick one and don’t mix (grams or troy ounces, not both). Store materials in a fixed location so missing stock is immediately obvious. Keep samples and display pieces separate from sellable inventory. Batch your recording into a weekly session rather than chasing every tiny movement in real time.

How often should I do a jewelry inventory count? Most small jewelry businesses do a full stocktake once or twice a year, with lighter cycle counts — counting one category at a time — monthly. High-volume sellers or those with many SKUs may benefit from more frequent cycle counting.

When should a jewelry maker switch from a spreadsheet to software? When manual recipe tracking becomes error-prone, when you sell across multiple platforms, or when you’re spending more than an hour a week on inventory admin. Software like Craftybase handles the materials-to-product deductions automatically and syncs with Etsy and Shopify.

Is there a free jewelry inventory template? Yes — download our free jewelry inventory spreadsheet template. It includes pre-built sheets for materials, finished goods, and basic recipe tracking.

Tracking your jewelry inventory doesn’t have to be a weekend project. Start with the free spreadsheet template, get your materials register in order, and write out recipes for your top ten products. That’s enough to get real visibility into your stock and your costs — and it’s the foundation for growing a jewelry business that’s actually profitable, not just busy.