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.
