Skip to content

Bead Inventory Spreadsheet: Count Beads, Cost Pieces

A free bead inventory spreadsheet for a jewelry maker: beads counted singly with cost per bead, findings, lots for color, and how many pieces stock can make.

By Koa Sterling. Product specialist at TaroStack and small business owner. Yes, I am a real human, and I actually sit in front of a computer and write these articles. Reviewed November 19, 2026 · 6 min read

Beads are bought by the strand, the bag or the gram, and used one at a time. A bead inventory spreadsheet bridges the two. It counts each bead singly, with the strand size in its name, so the cost of one bead is the strand's price divided by the beads on it: a $7.92 strand of 24 is 33 cents a bead. With that, the sheet can do the two jobs a jewelry maker needs: say what a finished piece costs, and say how many pieces the drawers can make. Findings, wire and finished pieces get their own rows, and a Lots sheet keeps each purchase apart, because the same bead from two shipments is rarely the same color. Below is a sheet for a made-up maker, and the file.

The short version

  • Count beads one by one. Seed beads by the gram.
  • Cost a bead = what the strand cost ÷ the beads on it, rejects left out.
  • Name each bead the same way: material, size, color.
  • Each purchase is a lot. Colors drift between lots.
  • Pieces you can make = the scarcest bead ÷ how many a piece takes.
  • TaroStack takes beads and findings off stock with each batch and says what you can make. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Sea glass beads, 8 mm, aqua (strand of 24) bead 312 240 $0.33 $102.96 OK
Sea glass beads, 8 mm, frosted white (strand of 24) bead 96 240 $0.33 $31.68 REORDER
Freshwater pearls, 6 mm (strand of 60) bead 420 180 $0.21 $88.20 OK
Sterling round beads, 3 mm (bag of 100) bead 640 400 $0.19 $121.60 OK
Lobster clasps, sterling, 9 mm each 72 60 $1.35 $97.20 OK
Bracelet, sea glass and pearl each 16 12 $9.85 $157.60 OK

Eleven rows in all, $822.26 of stock, with frosted white sea glass to reorder.

What a piece costs

In one bracelet Count Each Cost
Sea glass beads, aqua 12 $0.33 $3.96
Freshwater pearls 8 $0.21 $1.68
Sterling round beads 12 $0.19 $2.28
Lobster clasp 1 $1.35 $1.35
Jump rings 2 $0.12 $0.24
Crimp tubes 2 $0.07 $0.14
Beading wire 0.7 ft $0.28 $0.20
Materials $9.85

That's materials only. Time, the card, the box and fees come on top: see batch cost calculator.

Count the rejects. Ten strands of pearls is 600 on paper. Fourteen had flat spots and went in the seconds jar, so 586 were usable, and the true cost is the strand's price over the good ones. For anything natural, sort a strand when it arrives and count what you'd actually use.

How many can you make?

Component On hand Per bracelet Bracelets
Sea glass, aqua 312 12 26
Freshwater pearls 420 8 52
Sterling rounds 640 12 53
Lobster clasps 72 1 72
The stock can make 26

The shop wants 24. The aqua allows 26, so the order fits with two to spare, and it will use up the whole aqua drawer. Reorder now, not after.

Lots, because colors drift

Received or made Item Lot Quantity Note
Oct 14 Sea glass, aqua SG-AQ-1014 480 beads Runs greener than the last lot
Aug 22 Sea glass, frosted white SG-FW-0822 240 beads
Sep 30 Freshwater pearls FP-0930 600 beads 14 rejected
Nov 10 Bracelet, sea glass and pearl BR-1110 12 Aqua SG-AQ-1014; pearls FP-0930

"Aqua" from October is greener than "aqua" from June. In one bracelet nobody would notice. In a wholesale order of 24 laid side by side in a shop's case, they would. Keep lots in separate bags inside the drawer, finish one before opening the next, and make a matching order from a single lot.

Naming, so you can find things

With a few hundred kinds of bead, the name is the filing system. Pick an order and never vary it: material, size, color, then the strand size in brackets. "Sea glass beads, 8 mm, aqua (strand of 24)" sorts next to every other sea glass bead. Put the same words on the drawer label. Metals and finished jewelry are covered in how to inventory jewelry.

Get the spreadsheet

Download the bead inventory spreadsheet. Four sheets: inventory with value and REORDER, lots, a count sheet, and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers. For stock listed online, see Etsy inventory spreadsheet, and for a market table, craft fair inventory sheet.

Where this stops working

One bracelet changes seven rows. Twelve bracelets in an evening is 84 subtractions, and nobody does them. The sheet is accurate on the day the beads arrive and wrong from the first piece made, and counting 312 beads to fix it is nobody's idea of a morning.

How TaroStack does it

TaroStack does the 84 subtractions when you record the batch.

Each piece is a recipe. Twelve aqua, eight pearls, twelve sterling, a clasp, two rings, two crimps, 0.7 ft of wire. Units convert, so wire bought by the spool and used by the inch is one item.

Recording a batch moves the stock. Twelve bracelets on, and seven kinds of bead and finding off, from the lots you used. The lots are noted on the batch record automatically.

"What could I make right now" says how many bracelets the drawers allow and which bead runs out first.

Cost follows what you paid. Each batch is costed from the strands it used, so when silver goes up the bracelet's cost does too.

A reorder list for beads and findings below their reorder points.

The job Spreadsheet In TaroStack
Subtract beads used Seven rows a piece Recorded with the batch
How many can I make Divide each row What could I make right now
Which lot of aqua is in these A note On the batch record
Cost at today's silver price Retype it From what you paid

Stock, lots, recipes and batches are on every plan, from $9.99 a month (5 recipes) or $39 a month (50 recipes). The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.

Questions people also ask

How do you keep track of bead inventory?

Count each kind of bead singly, name them in a fixed order (material, size, color), and keep each purchase as its own lot. Seed beads are easier by the gram.

How do you work out the cost of one bead?

Divide what the strand or bag cost, shipping included, by the number of usable beads in it.

Should I count beads or weigh them?

Count beads you use a few at a time. Weigh seed beads and anything too small to count: weigh ten grams, count them once, and use that figure.

We use AI to help with the research for these articles. Every one is read, checked against its sources and edited by Koa before it's published. Spot a mistake? Tell us and we'll fix it and say so. How we write these.

Let’s get your stack in order.

Get TaroStack

Sign up now for your free 14 day trial. No credit card required.