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

    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.