Free Download

Free Jewelry Inventory Spreadsheet

Track Every Bead, Finding, and Finished Piece — Free

Download our FREE jewelry inventory spreadsheet to track beads, wire, findings, gemstones, metals, chains, component costs, finished piece inventory, and COGS for your jewelry making business.

Trusted by 3,000+ makers
Free jewelry inventory spreadsheet for jewelry makers
Excel Numbers Google Sheets

Join the Craftybase mailing list and we'll send you our jewelry inventory spreadsheet template for free! We typically send 2-4 emails a month about small batch production topics which we hope are useful to our readership.

Stop losing track of jump rings, running out of clasps mid-batch, and guessing what each piece costs to make

If you're tracking jewelry inventory in your head — knowing roughly how many beads you have, guessing when to reorder clasps, and hoping you don't run out of wire mid-project — you're not alone. But here's the thing: jewelry making means juggling hundreds of tiny components, each with its own cost and reorder point. Without a system, it's impossible to know your true costs or scale without chaos.

This free jewelry inventory spreadsheet helps you track everything that goes into making jewelry — from beads and wire to findings, gemstones, metals, chains, and finished pieces. It calculates component costs, per-piece COGS, and inventory values so you can see exactly what you have on hand and what each piece costs to produce.

  • Component tracking for beads, wire, findings, gemstones, metals, chains, cords
  • Finished jewelry inventory by SKU/style with stock status
  • Per-piece cost calculation (COGS per necklace, earring, bracelet, ring)
  • Purchase tracking with supplier and landed cost calculations
  • Production log for material usage per piece
  • Compatible with Excel, Numbers, and Google Sheets

Perfect for beaders, wire wrappers, metalsmithing hobbyists-turned-sellers, and small jewelry businesses who want to get serious about inventory without investing in software yet.

Track Every Component

Know exactly how many jump rings, clasps, and beads you have on hand. See when you're running low on wire or gemstones before you run out mid-production.

Calculate Piece Costs

Track component usage for each jewelry design. Know exactly how much wire, beads, and findings go into each piece, and what it costs per unit to produce.

Manage Finished Inventory

Track finished jewelry by SKU with stock levels, manufacture costs, and inventory values. See what's ready to sell and what needs to be restocked.

Ready to get your jewelry inventory under control?

Our free spreadsheet template helps you track every bead, finding, and finished piece — so you can stop guessing and start growing.

Download the free spreadsheet ↑

Excel, Numbers & Google Sheets compatible

How to Use the Jewelry Inventory Spreadsheet

This jewelry inventory spreadsheet is designed to help you track the complete lifecycle of your jewelry business — from raw components to finished pieces. It's perfect for jewelry makers who need organized inventory data without the complexity of full inventory software.

To get started, if you haven't already downloaded the spreadsheet, enter your email address above. You'll receive a link to download the file as a zip. Once unzipped, you can open it in Excel, Numbers, or upload it to Google Sheets.

Important note: Some columns are calculated automatically and should not be edited manually. These are typically marked with a light turquoise background color.

1

Material Inventory

This is your master materials list — every component you use to make jewelry. For beads, wire, findings (clasps, jump rings, earring hooks, lobster claws), gemstones, metals, chains, cords, and any other materials, you'll track key details including an optional SKU, description, stock status (auto-calculated), starting quantity, inventory value, and preferred vendor.

Name
A clear identifier for each component (e.g., "4mm Czech Glass Beads - Cobalt Blue", "20ga Sterling Silver Wire", "Lobster Clasp - Antique Brass", "8mm Round Amethyst Beads").
On Hand Qty
How much of this component you currently have in stock. Update this regularly through cycle counting or after each production run.
Unit Cost
What you paid per unit of this component. This should be the fully landed cost — including shipping and any bulk discounts. For example, if you bought 1000 jump rings for $25 including shipping, your unit cost is $0.025 per ring.
Tracking Unit
How you measure this component. Examples: "each" for beads, jump rings, clasps; "inches" or "feet" for wire and chain; "grams" for precious metals; "strands" for strung beads.

Pro tip: Jewelry inventory typically includes hundreds of small components. Group similar items by category (e.g., all jump rings together, all clasps together) to make stocktaking easier. Consider using bin locations or drawer labels that match your spreadsheet SKUs.

2

Personal Use

This tab tracks components you've taken out of business inventory for personal use — jewelry pieces you kept for yourself, gifts to family, or samples you didn't sell. Logging this ensures you're not claiming personal usage as a business expense.

Date Removed
When you took these components out of inventory for personal use.
Name
The name of the component removed from inventory, along with optional SKU and description for identification.
Quantity Used
How many units you removed. For example, if you took 20 beads and 2 clasps for a personal bracelet, enter separate rows for each component.
Total Cost
Automatically calculated based on unit cost and quantity. This is how much the personal use withdrawal cost your business.
3

Purchases

This tab logs every component purchase you make throughout the year. By tracking purchases, you can see total expenses and calculate end-of-year inventory values for tax purposes. Create a separate row for each component in a purchase order — if you bought 500 jump rings, 100 clasps, and 50 yards of chain from the same supplier, that's 3 rows.

Vendor & Date
Who you bought from (e.g., "Fire Mountain Gems", "Rio Grande", "Artbeads") and when you ordered or received the components.
Quantity Purchased
How many units you bought (e.g., 1000 jump rings, 50 yards of chain, 200 beads). Include item cost, SKU, and description for each line.
Shipping & Tax
Your proportional share of shipping and tax for this item. Allocate by weight, cost, or evenly — whatever makes sense for your order.
Landed Unit Cost
Automatically calculated. This is the true cost per unit including shipping and tax — the number you should use for pricing and profitability calculations.
4

Manufactures

This is where you log production — every time you make a piece of jewelry. By tracking component usage per piece, you can calculate accurate costs per item and understand your true margins. Log each component used in a piece as a separate row for precise tracking.

Product Name
The jewelry piece you're making (e.g., "Amethyst Drop Earrings with Sterling Hooks"), along with SKU and manufacture date.
Material Name
The component used in this piece (e.g., "8mm Amethyst Round Beads"), with SKU and unit cost from your Material Inventory tab.
Quantity Used
How many units of this component you used. For example, if you used 12 beads in a necklace, enter "12". This is subtracted from your on-hand inventory.
Total Material Usage Cost
Automatically calculated (quantity used × unit cost). This is how much this component cost in this piece.

Pro tip for jewelry costing: Don't forget to include every component — even the tiny ones. A pair of earrings might include beads, wire, headpins, jump rings, and earring hooks. Each component adds to your cost. Missing even $0.50 per piece means leaving money on the table across hundreds of sales.

5

Product Inventory

This tab tracks your finished jewelry inventory — pieces that are made and ready to sell. You'll see at a glance what you have in stock, what each piece costs to make, and the total value of your finished goods inventory. Additional fields include category, description, unit price, starting quantity, and stock status.

Name & SKU
Your product identifier (e.g., "NECK-LAV-18IN", "EARR-TURQ-STUD"). Essential for multichannel selling where SKUs keep products synced across Etsy, Shopify, and wholesale.
On Hand Qty
How many finished pieces you currently have ready to sell. Update this after production runs and sales. Stock status is auto-calculated.
Manufacture Cost
How much it costs in components to make one piece. Calculated from your Manufactures tab by adding up all component costs per unit (beads + wire + findings + labor).
Current Inventory Value
Automatically calculated. The total value of all on-hand units based on manufacture cost. This is your finished goods inventory value for this product.
6

Orders

This tab tracks all jewelry sales. By logging each sale and the associated cost of goods, you can calculate total revenue, COGS, and gross profit for the year. Create a separate row for each product in an order — if a customer bought 2 pairs of lavender earrings and 1 necklace, that's 2 rows.

Order Date & ID
When the order was placed and your unique order number (from Etsy, Shopify, Square, or your own numbering system).
Quantity Sold
How many units of this product were in the order, along with SKU, name, and unit price for each line item.
Unit Manufacture Cost
The cost to make one piece (from your Product Inventory tab). This is your Cost of Goods Sold (COGS) per unit.
Grand Total
Automatically calculated. The total revenue for this line item including tax and shipping. Also calculates total price and total manufacture cost.
7

Reports

This tab tallies up your key financial numbers for the year. Everything here is automatically calculated from the other tabs — do not edit these numbers manually.

Total Revenue
Sum of all sales for the year, pulled from your Orders tab.
Total Component Purchases
Sum of all component purchases for the year, pulled from your Purchases tab.
Total COGS
Total cost of goods sold — the manufacturing cost of all jewelry you sold during the period.
Inventory Values
Starting and ending inventory values for tax reporting, plus personal use deductions.

These numbers are what you'll need for tax time, bookkeeping, and understanding whether your jewelry business is actually profitable. Make sure your component unit costs are accurate — if you're using old prices or forgetting to include shipping, your profitability numbers will be off. For precious metals especially, update prices regularly as market rates fluctuate.

What is a Jewelry Inventory Spreadsheet?

A jewelry inventory spreadsheet is a structured document that helps jewelry makers track raw components (beads, wire, findings, gemstones, metals, chains), production, finished jewelry inventory, and sales. It's essentially a material and product tracking system tailored to the specific needs of jewelry businesses — tracking hundreds of small components, each with its own cost and reorder point.

Think of it as a combination of a component tracker, piece costing tool, and sales log. For every piece of jewelry you make, the spreadsheet helps you document what components went into it, how much they cost, and what your profit margin is after selling. It also tracks on-hand inventory so you know when to reorder supplies before you run out of critical findings mid-batch.

Unlike a simple stock count, a good jewelry inventory spreadsheet goes deeper — it tracks bills of materials (BOMs) for each design, calculates COGS per piece, and gives you inventory valuation numbers you need for tax reporting. It's especially important for jewelry because of the high SKU count — most jewelry makers have 50-200+ finished product SKUs, each made from 5-15 different components. Learn more about jewelry business inventory management.

Why do jewelry makers need inventory tracking?

The most common reason jewelry makers hit a growth wall is poor inventory visibility. You think you have enough jump rings for the market this weekend, but you're actually 50 short. You reorder lobster clasps only to find you already had two cards buried in the drawer. You price pieces based on rough guesses instead of actual costs, and you're not sure if you're making money or just staying busy.

Inventory tracking solves this. With organized data, you know exactly what components you have on hand, what you need to reorder, and what each piece costs to produce. This means:

No more stockouts mid-production.
You can see when wire or clasps are running low and reorder before you're stuck pausing work during peak season.
Accurate pricing.
You know your real costs — every bead, finding, gemstone, and metal — so you can set prices that actually cover expenses and leave room for profit. Learn how to price handmade jewelry.
Better purchasing decisions.
Should you buy beads in small packs or bulk? Is buying precious metal by the gram or by the ounce more cost-effective? With cost data, you can compare unit prices and make smarter buying choices.
Tax-ready COGS.
At year-end, you'll have accurate cost of goods sold (COGS) numbers for tax filing. No more scrambling through receipts in April.

And if you're running a profitable jewelry business — or trying to — you need to know your margins. That means tracking not just revenue, but costs per piece. A spreadsheet is the simplest way to start doing that. Read more about how to start a jewelry business.

What should a jewelry inventory spreadsheet track?

A comprehensive jewelry inventory spreadsheet should cover the full production cycle — from raw components to finished pieces. At a minimum, it should include:

Component Inventory:
A master list of all materials — beads (by size, color, material, finish), wire (by gauge and metal type), findings (clasps, jump rings, earring hooks, headpins, crimp beads), gemstones, metals, chains, cords. For each component, track on-hand quantity, unit cost, tracking unit (each, inches, grams), and preferred vendor.
Purchase Tracking:
A log of every component purchase with date, vendor, quantity, cost, shipping, and tax. Essential for jewelry because you often buy from multiple specialty suppliers — bead shops, metal suppliers, gemstone dealers — each with different pricing structures.
Production Log:
Record each piece you make. List what jewelry you created, what date you made it, and what components you used. Critical for jewelry because even small pieces can include 5-15 different components.
Finished Inventory:
Track your ready-to-sell jewelry by product, quantity on hand, unit price, and manufacture cost. For jewelry makers with 50+ SKUs, this helps prevent overselling and ensures you restock popular designs.
Sales/Orders:
Log every sale with order date, product, quantity, price, and manufacture cost. Especially important for jewelry sold across multiple channels (Etsy, Shopify, craft fairs, wholesale).
Reports:
Calculated totals for revenue, expenses, COGS, inventory values, and profit. These are the numbers you need for taxes and to understand if your business is sustainable.

Why spreadsheets may not be enough as your jewelry business grows

A jewelry inventory spreadsheet is a great starting point — especially if you're making small batches for local markets or testing designs. But as your business grows — more products, more SKUs, more sales channels — spreadsheets can become a bottleneck.

Here's what usually breaks first: Jewelry makers typically manage 100-300 component SKUs and 50-200 finished product SKUs. Each product is made from 5-15 components. Tracking all this manually means entering hundreds of transactions per month. Miss one, and your inventory is wrong.

Spreadsheets also struggle with cost accuracy for jewelry. If you buy jump rings at different prices over time (which every jewelry maker does — prices fluctuate, you find better suppliers, you buy on sale), calculating true COGS requires choosing a cost flow method — FIFO, LIFO, or weighted average. Most spreadsheets don't handle this well. You end up using rough average costs, which means your profitability numbers are estimates, not reality.

That's where jewelry inventory software like Craftybase comes in. Instead of manually tracking every component use, Craftybase does it automatically. When you log a purchase, it updates component costs and on-hand quantities. When you make a piece of jewelry, it deducts components from inventory and calculates the cost based on your actual purchase prices using FIFO or weighted average costing. When you sync sales from Etsy or Shopify, it updates finished goods inventory and calculates COGS in real time. Read about the best jewelry inventory software options.

When to switch from a spreadsheet to jewelry inventory software

If any of these sound familiar, it's probably time to move beyond spreadsheets:

  • You're spending more time updating the spreadsheet than making jewelry.
  • You're managing 50+ component SKUs and 20+ finished product SKUs and can't keep up with manual data entry.
  • You're selling on multiple channels (Etsy, Shopify, craft fairs, wholesale) and can't keep inventory synced.
  • You've run out of critical findings mid-batch because the spreadsheet wasn't up to date.
  • You're not sure what your true COGS is because component costs keep changing and the spreadsheet can't handle FIFO or weighted average costing.
  • You're working with a team and need multiple people to access and update inventory without emailing spreadsheets back and forth.
  • You're ready to scale — doing wholesale, expanding product lines, or opening a retail space — and need inventory accuracy you can trust.

Craftybase is built for small batch jewelry makers who want the accuracy of real-time inventory tracking without enterprise complexity or cost. It tracks components, designs, production, and sales in one system. And because it's cloud-based, you can check stock levels from anywhere — whether you're at a market, in your studio, or meeting with a wholesale buyer.

Jewelry Inventory Spreadsheet FAQ

To calculate cost per piece, list every component used in the design (beads, wire, findings, gemstones, chain, etc.) and determine the cost per unit. Multiply the quantity used by the unit cost for each component, then sum all component costs. For example, if you use 24 beads at $0.40 each, 8 inches of wire at $0.15/inch, 2 jump rings at $0.05 each, 1 clasp at $0.30, and 2 crimp beads at $0.02 each, your total component cost is $11.04. Don't forget to factor in labor if you're pricing for wholesale or want to understand true profitability.

Track precious metals (sterling silver, gold-filled, solid gold) by weight (grams or troy ounces) because prices fluctuate based on market rates. This gives you accurate cost tracking when metal prices change. For base metals (brass, copper, aluminum), tracking by piece or by length (for wire and chain) is usually sufficient since prices are more stable. Update your precious metal costs regularly to reflect current market prices for accurate piece costing.

Component waste (trim from wire cuts, broken beads, failed pieces) should be tracked separately. When you cut 10 inches of wire but only use 8 inches in the finished piece, log 10 inches as depleted from inventory — the 2 inches of waste is a real cost. Some jewelry makers create a "waste/scrap" category to track this separately. For precious metals, save scrap for recycling and track it as a separate inventory item with estimated recovery value.

Most successful jewelry businesses aim for 50-75% gross profit margins on direct-to-consumer sales. This means if a pair of earrings costs you $8 to make (including all components), you'd price them at $16-$32 retail. For wholesale, margins are typically tighter — around 40-50% — because you're selling at wholesale price (usually 50% of retail). Fine jewelry with precious metals and gemstones can command higher margins, while fashion jewelry may be lower due to market competition. Your target margin should cover all business expenses (booth fees, marketing, packaging, labor) and still leave room for net profit.

Set reorder points based on your typical usage rate and supplier lead time. For example, if you use 200 jump rings per week and your supplier takes 5 days to ship, set your reorder point at 300-400 jump rings to give yourself a buffer. Track on-hand quantities in your spreadsheet and flag items that drop below your reorder point. For seasonal businesses or before major craft fairs, increase safety stock for high-use components. Track which designs sell best and ensure you have enough components to make more.

COGS (Cost of Goods Sold) for jewelry is the total component cost of all jewelry you sold during a period. It includes beads, wire, findings, gemstones, metals, chains, and any other materials that go into finished pieces — but not general business expenses like marketing, booth fees, or tools. Calculate COGS by multiplying units sold by the manufacture cost per unit for each product, then summing across all products. For example, if you sold 20 pairs of earrings at $6.50 cost each and 10 necklaces at $15 cost each, your COGS is $280. This number is required for tax reporting and calculating gross profit. Learn more about COGS

Yes — always track different sizes, colors, and finishes as separate inventory items. A 4mm cobalt blue Czech glass bead is not interchangeable with a 6mm cobalt blue Czech glass bead, even though they're the same color and type. Each variation has different costs, uses, and reorder needs. Use clear SKUs or naming conventions to distinguish them (e.g., "CZECH-4MM-COBALT" vs "CZECH-6MM-COBALT"). This ensures accurate cost calculations per piece and helps you maintain design consistency.

Ideally, update inventory in real-time — log purchases when components arrive, log production when you make pieces, and log sales when orders ship. In practice, most makers update daily or after each production session. The more frequently you update, the more accurate your stock levels and cost data will be. If you're only updating weekly or monthly, you risk running out of critical components or having stale cost data. For growing businesses managing 50+ SKUs, consider moving to automated inventory software that updates in real-time without manual entry.

Who Should Use This Jewelry Inventory Template?

This free jewelry inventory spreadsheet is designed for jewelry makers at any stage who need to organize components, track costs, and understand profitability.

Beaders and wire wrappers transitioning to selling

If you've been making jewelry as a hobby and are now starting to sell at craft fairs, farmers markets, or online, this template helps you move from hobby pricing to business pricing. You'll learn what it actually costs to make each piece and how to set prices that cover materials and leave room for profit.

Etsy and Shopify jewelry sellers

If you're selling jewelry online and juggling component orders from multiple suppliers, production batches, and sales across platforms, this spreadsheet gives you a central place to track everything. You'll know what components you have in stock, what you need to reorder, and what each sale cost you in materials.

Small jewelry business owners

If you're running a jewelry business with a core product line (10-50 designs), this template gives you the inventory foundation you need without investing in software. It's perfect for tracking components, calculating COGS, and keeping your numbers organized for tax season.

Jewelry makers testing new designs

Before you launch a new design, use this template to calculate whether it's worth making. You'll see the component costs and margins before you commit to production — helping you avoid designs that look beautiful but don't make financial sense when you factor in the cost of gemstones, precious metals, or specialty findings.

Wholesale jewelry makers

If you're supplying jewelry to boutiques, gift shops, galleries, or other retailers, accurate costing is critical. Wholesale pricing is typically 50% of retail, which means tighter margins. This template helps you calculate costs precisely so you can quote wholesale prices that cover expenses and still leave room for profit.

Precious metals and gemstone jewelers

If you're using sterling silver, gold-filled wire, or gemstones, tracking costs becomes even more critical because material prices fluctuate. This spreadsheet helps you track component costs by weight or unit, update prices as market rates change, and understand your true margins on high-value pieces.

Jewelry designers with high SKU counts

If you're managing 50-200 component SKUs and 20-100 finished product SKUs, this spreadsheet helps you stay organized. You'll know exactly what you have on hand for each component variation and what needs restocking — critical for maintaining production flow and design consistency.

Jewelry makers preparing for growth

If you're considering scaling your jewelry business — adding wholesale accounts, expanding your product line, doing custom orders, or opening a retail space — this spreadsheet gives you the cost visibility you need to make informed decisions. Once you outgrow it, you'll have clean data to migrate to jewelry inventory software like Craftybase.

Ready to outgrow the spreadsheet?

Streamline your end-to-end jewelry making process and gain real-time visibility into your inventory with Craftybase. Built for jewelry makers who need to track hundreds of components, calculate accurate COGS across dozens of designs, and maintain inventory accuracy without spreadsheet headaches.

Start a 14 day free trial →

No credit card required. Cancel anytime.