Skip to content

Fabric Inventory Spreadsheet: Yards, Rolls and Dye Lots

A free fabric inventory spreadsheet for a sewing business: yards on each bolt, cost a yard, roll and dye lot, notions, reorder amounts, and yards per product.

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 · 5 min read

A sewing business's fabric inventory comes down to yards on bolts, and two facts about each bolt that a simple list forgets: what it cost a yard and which roll and dye lot it is. Cost a yard is your product cost. The dye lot is why the navy bag sewn in August doesn't quite match the navy bag sewn in November. A fabric inventory spreadsheet tracks both, with notions (zippers, webbing, thread, labels) on the same sheet and finished goods at the bottom. Here's one for a made-up maker of canvas bags.

The short version

  • One row for each fabric, color and width, counted in yards.
  • Cost a yard, shipping included.
  • Each roll received gets a row with the mill's roll number and dye lot.
  • Notions in yards or eaches, with reorder amounts.
  • TaroStack takes the yards off the bolt for every batch you cut and sew. More below.

An example sheet

Driftwood Canvas Co. is a made-up maker in Portsmouth, New Hampshire. Six of its nine rows:

Item Unit On hand Reorder at Unit cost Value Status
Canvas, 10 oz natural, 60 in yd 46 30 $14.00 $644.00 OK
Canvas, 10 oz navy, 60 in yd 18 20 $14.50 $261.00 REORDER
Waxed canvas, olive, 58 in yd 12 10 $22.00 $264.00 OK
Cotton lining, stripe, 44 in yd 30 15 $6.25 $187.50 OK
Webbing, cotton, 1.5 in yd 85 60 $0.85 $72.25 OK
Zippers, brass, 9 in each 64 50 $1.10 $70.40 OK

Thread, woven labels and 22 finished totes bring it to $2,051.41. Navy canvas is under its reorder amount.

Yards into products

A tote takes 0.6 yard of 60-inch canvas, with the handles cut from the same piece.

Natural Navy
Yards on hand 46 18
Totes that cuts (÷ 0.6) 76 30
Wholesale order on the table 36 navy
Short by 6 totes, 3.6 yd

So the navy order can't be cut from what's here. That's worth knowing before you promise a ship date, and it leads straight into the next problem.

Dye lots

Received Item Roll and dye lot Yards Note
Oct 6 Canvas, natural Roll 4471, dye lot N-88 50
Aug 18 Canvas, navy Roll 4102, dye lot B-31 40 Next roll may not match
Nov 3 Waxed canvas, olive Roll W-209 15

Mills dye in batches, and two rolls of "navy" from different batches can differ by a shade you only see when the bags sit side by side in a shop. The fix for the 36-tote order is to cut all 36 from the new roll and use the 18 yards of B-31 for single orders, not to cut 30 from the old and 6 from the new. You can only make that call if the dye lot was written down when the roll came in.

For matched sets (a tote and a pouch sold together), cut both from one roll and note it. The idea is the same as a food maker's lot: see what is lot tracking.

What isn't counted

Scraps. This maker doesn't count pieces under half a yard; they go in a bin for zipper pulls and samples. Decide your own cutoff and stick to it, or the count takes all day. The cost of what's wasted in cutting is already in the 0.6 yard a tote, which includes the offcuts. How that's worked out is in how to calculate cost per inch of fabric.

Get the spreadsheet

Download the fabric inventory spreadsheet. Four sheets: inventory with value and REORDER, rolls and dye 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. A plan for a bag business is in tote bag business plan.

Where this stops working

Cutting day takes yards from four bolts, plus zippers, webbing and labels, and nobody measures a bolt after cutting to update a sheet. By the time the count is wrong enough to notice, there's a wholesale order riding on it.

How TaroStack does it

TaroStack takes the yards off as the bags are made.

Each product is a recipe. A tote: 0.6 yd of canvas, 0.4 yd of lining, 1.5 yd of webbing, a label. Record a batch of 36 and 21.6 yards of canvas come off the roll you cut from.

Rolls are lots. Each roll is received with its roll number and dye lot. The batch record notes which roll it was cut from, so a set stays a set.

It answers the order question. "What could I make right now" shows how many totes the fabric and notions on hand allow, and what runs out first.

Cost follows the roll. When the next roll costs $15.25 a yard, totes cut from it cost more, and margins by product show it.

The job Spreadsheet In TaroStack
Yards left after cutting Measure and retype Come off with the batch
Enough navy for 36 totes? A sum Shown for you
Which roll a bag came from Not recorded On the batch record
Zippers and webbing Watch for red A reorder list

Recipes, batches and lots 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 fabric inventory?

List each fabric by color and width with the yards on hand and the cost a yard, record each roll's dye lot, and subtract what every cutting session uses.

How do you measure fabric left on a bolt?

Unroll and measure, or count the folds on a flat-fold bolt and multiply by the fold length. For rolls, weigh them if you know the weight a yard.

What is a dye lot?

A batch of fabric or yarn dyed together. Color can vary slightly between lots, so matched items are cut from one.

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.