Skip to content

Embroidery Floss Inventory Spreadsheet: By Color Number

A free embroidery floss inventory spreadsheet: skeins by color number, where each is kept, what to reorder, dye lots, and how many kits your floss will pack.

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 20, 2026 · 7 min read

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.

Questions people also ask

How do I keep track of my embroidery floss?

List each color by its number with the whole skeins you have and where they're kept, sort the drawers in number order, and count part-used skeins as none.

How do I know how many kits I can make from my floss?

For each color, divide the skeins on hand by the skeins one kit takes. The smallest result across the kit's colors and other parts is the number of kits.

Do dye lots matter for embroidery floss?

Less than for yarn, but they can differ slightly. For a large piece or a run of kits, use one dye lot of each color.

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.