Floss is hundreds of colors that look alike in a drawer and nothing alike in a finished piece, so a floss inventory is kept by color number, one row a color, counted in whole skeins. Beside each: where it's kept, so you can find it, and a level to reorder at, so you don't run out mid-project or buy a color you already have three of. If you sell kits, the sheet does one more job. A kit takes fixed skeins of several colors, and the color with the fewest left decides how many kits you can pack. And when a batch of kits or a large piece needs its colors to match exactly, the dye lot from the skein's band is worth a column. Below is a sheet for a made-up maker of cross stitch kits, the kit sum, and the file.
The short version
- One row for each color number. The number, then a name you'll recognize.
- Count whole skeins. A part-used skein on a bobbin counts as none.
- Write where each color lives.
- A reorder level: what your next two projects or kit runs need.
- For kits: skeins on hand ÷ skeins a kit takes, for each color. The smallest answer wins.
- TaroStack takes the skeins off each color when kits are packed. More below.
An example sheet
| Item | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|
| Stranded cotton, black (310) | skein | 9 | 4 | $0.62 | $5.58 | OK |
| Stranded cotton, white (blanc) | skein | 7 | 4 | $0.62 | $4.34 | OK |
| Stranded cotton, ecru | skein | 3 | 3 | $0.62 | $1.86 | REORDER |
| Stranded cotton, red (321) | skein | 2 | 3 | $0.62 | $1.24 | REORDER |
| Stranded cotton, dark green (890) | skein | 5 | 3 | $0.62 | $3.10 | OK |
| Stranded cotton, sage (3053) | skein | 1 | 3 | $0.62 | $0.62 | REORDER |
Thirteen rows in all with cloth, hoops, needles and finished kits: $138.54 of stock. Three colors are at or under their level.
A hobbyist's sheet might have four hundred rows and no cost column. The idea is the same: number, skeins, place.
Counting floss
Whole skeins only. A skein with a few lengths pulled is a working skein, not stock. Count it as none, and keep working skeins on bobbins in a project box apart from the full ones. Otherwise the sheet says you have a skein of sage and the drawer has two feet of it.
By number, in number order. Sort the drawers and the sheet the same way, so a count is a walk down the drawer with the sheet beside it.
Write the place. "Drawer 2" is enough. The point is that the sheet can find a color faster than you can.
Mind the look-alikes. Ecru and white, two greens a shade apart. That's what the number is for: file by it, not by eye.
The kit sum
One 'Winter Pine' kit takes:
| From | A kit takes | On hand | Kits it allows |
|---|---|---|---|
| Dark green (890) | 2 skeins | 5 | 2 |
| Sage (3053) | 1 skein | 1 | 1 |
| White | 1 skein | 7 | 7 |
| Red (321) | 1 skein | 2 | 2 |
| Aida cloth, 15 x 18 in | 1 piece | 11 | 11 |
| Hoop, 6 in | 1 | 14 | 14 |
| Needle | 1 | 54 | 54 |
| Kits you can pack | 1 |
Plenty of cloth and hoops, and one kit is all there is, because sage is down to its last skein. The sheet flagged sage. The kit sum says what that flag costs: with a dozen orders waiting, eleven can't ship until one 62-cent color arrives.
The kit's cost is the sum of its parts: five skeins at $0.62, cloth at $2.80, a hoop at $1.90, a needle at $0.20 and a printed pattern at $0.12. That's $8.12. What to charge for it is in how to price embroidery.
Dye lots
Floss makers hold their colors closely, but dye lots can still differ a little, and the difference shows where one skein ends and the next begins in a large filled area. Two habits help. For a big piece, buy all the skeins of a color at once. For a run of kits, pack them from one dye lot of each color and note the lot against the run, so a customer who needs one more skein can be sent a match, or warned that it may not be one.
In the example, the twelve skeins of dark green for the Winter Pine kits were all dye lot 4471. The same care with yarn is in dye lot number on yarn. A sheet for yarn is in yarn inventory spreadsheet, and for cloth in fabric inventory spreadsheet.
Setting the reorder level
For a color that's in a kit: the skeins one kit takes, times the kits you sell in the time it takes floss to arrive, plus a few. If Winter Pine sells ten a month, floss takes a week to come, and a kit takes two dark green, the level is about five to cover the week, and you order twenty at a time.
For a color that's only for your own stitching: two skeins of anything you use often, none of anything you bought for one project.
Get the spreadsheet
Download the embroidery floss inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, lots for dye lots and kit runs, a count sheet to print, and a read-me. Add a row for each color you own. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
Packing twelve kits takes skeins from five colors, cloth from a pile, hoops from a box. That's seven rows of the sheet to change by hand, every time you pack. Nobody does it. So the sheet is right after a count and drifts until the next one, and the kit sum, which is the reason to have the sheet, is the first thing to go wrong.
How TaroStack does it
TaroStack changes all seven rows when you record the kits.
A kit is a recipe. Two dark green, one sage, one white, one red, cloth, hoop, needle, pattern. Record twelve kits packed and each of those goes down by exactly that.
"What could I make right now" says how many kits your floss allows and which color stops you.
Each kit run is a batch, and its record notes which lots it used, automatically: the dye lot of each color.
The kit's cost is real, from what the skeins actually cost you.
A reorder list in days of cover, by supplier, so sage is ordered before the last skein.
| The job | Spreadsheet | In TaroStack |
|---|---|---|
| Take a kit's skeins off stock | Seven rows by hand | Record the kits |
| How many kits can I pack | Work it out color by color | What could I make right now |
| Which dye lot is in this run | A note, if written | On the batch record |
| When to reorder a color | A flag, after the last count | The reorder list |
Starter, at $9.99 a month, holds 50 items and 5 recipes, which fits a small range. A full wall of colors wants Growth: 3,000 items and 50 recipes at $39 a month. 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.
