Skip to content

Quilt Shop Inventory Sheet: Bolts, Precuts, Kits, Ends

A quilt shop inventory sheet: bolts by the yard, precuts, batting, notions and kits, what a kit takes from each bolt, bolt ends and remnants, with a file.

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

A quilt shop's stock is fabric on bolts, and a bolt is never a whole number for long. So a quilt shop inventory sheet counts bolts in yards, to the quarter, one row for each print. Beside those it counts precuts (fat quarter bundles, strip rolls) by the each, batting by the yard, notions by the each, and kits, which are the interesting part: a kit takes fixed yardage from several bolts at once, and the bolt with the least left decides how many you can cut. At the other end of a bolt's life is the remnant: under a yard, off the wall, into the bin. Quilting collections are usually printed once, so when a bolt runs out there's no reordering it. Below is a sheet for a made-up shop, the kit sum, and the file.

The short version

  • Bolts in yards, to the nearest quarter. Measure, don't guess from thickness.
  • One row for each print and color.
  • A kit is a recipe: so many yards from each bolt. The shortest bolt limits it.
  • Collections are one print run. Decide what to kit before the bolts are cut for customers.
  • Under a yard is a remnant. Move it off the bolt row.
  • TaroStack takes the yardage off each bolt when kits are cut. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Quilting cotton, 'Meadow' floral, blue yd 9.5 4 $6.40 $60.80 OK
Quilting cotton, 'Meadow' stripe, cream yd 2.25 4 $6.40 $14.40 REORDER
Solid, navy yd 22 10 $4.60 $101.20 OK
Fat quarter bundle, 'Meadow', 12 pieces each 6 4 $22.00 $132.00 OK
Kit: 'Meadow Lap Quilt' each 4 3 $42.00 $168.00 OK
Remnants, under 1 yd piece 37 0 $2.00 $74.00 OK

Twelve rows in all, $1,235.80 of stock at cost. The stripe and the strip rolls are flagged, and for a collection print "REORDER" may mean "it's gone".

The kit sum

One 'Meadow Lap Quilt' kit takes:

From Yards a kit On the bolt Kits it allows
'Meadow' floral, blue 3 9.5 3
'Meadow' stripe, cream 1.5 2.25 1
Solid, navy 2 22 11
Pattern 1 12 12
Kits you can still cut 1

Eleven kits' worth of navy and three of floral, and one kit is all that's left, because the stripe is down to two and a quarter yards. Six kits were cut on November 4 and used nine yards of a fifteen-yard bolt. The rest went to customers by the half yard.

That's the lesson of a collection: decide the kit count when the bolts arrive. Fifteen yards of stripe is ten kits and nothing for the wall, or six kits and six yards for customers, and it can't be changed in week five. Work out the kits first, set that yardage aside, and sell the remainder.

The kit's cost is the sum of its parts: 3 yd at $6.40, 1.5 yd at $6.40, 2 yd at $4.60 and a $4.00 pattern, $42.00. What to charge for it, and for finished quilts, is in how to price quilts.

Measuring a bolt

Counting bolts is quick. Knowing what's on them isn't. Three ways, fastest first:

Method How Good to
Count the folds Each fold on a standard bolt board is about half a yard A yard or so
The bolt-end tally Start at the bolt's yardage and subtract every cut on a card tucked in the board The quarter yard, if every cut is written
Unroll and measure On the cutting table Exact

Most shops use the tally and unroll at the yearly count. Whichever you use, the sheet wants a number to the quarter yard.

Bolt ends

Rule in this shop
A yard or more left Stays on the wall, on its own row
Under a yard Rolled, tagged with the yardage, into the remnant bin at a set price
Under a quarter Scrap bags, sold by weight

Move the yardage when the piece moves. Thirty-seven remnants at $2 of cost each is $74 the sheet would otherwise show as fabric on bolts that aren't there. It's also real money: remnants sell.

Dye lots and print runs

Solids come in dye lots, and navy from two lots can differ enough to show in a border. Keep the lot from the bolt end, and cut a customer's whole order from one bolt. Prints come in runs, and a reprint of a popular collection can shift in color. Note the run. The same problem in yarn is in dye lot number on yarn. A sheet for a maker's own fabric stash, as opposed to a shop's wall, is in fabric inventory spreadsheet, and a business that quilts for others in longarm quilting business plan.

Get the sheet

Download the quilt shop inventory sheet. Four sheets: inventory with value and REORDER, lots for bolts and kit runs, 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.

Where this stops working

A shop has eight hundred bolts. Each sale is a cut from one or more of them, by the quarter yard, forty times a day. Nobody subtracts those on a spreadsheet, so the yardage column is true once a year. In between, the only way to know whether there's enough stripe for a kit is to walk to the wall and unroll it.

How TaroStack does it

TaroStack takes the yardage off a bolt when a cut is recorded.

A bolt is a lot. Each bolt arrives with its yardage, its print run or dye lot and what it cost. Stock is in yards, to whatever fraction you sell.

A kit is a recipe. Three yards of floral, one and a half of stripe, two of navy, a pattern. Record six kits cut and each bolt goes down by exactly that, noted on the batch record.

"What could I make right now" says how many more kits the bolts allow and which bolt stops you.

The till. TaroStack connects to Square.

Bolt ends are a count. Count the bolt at zero and the remnant bin one higher, and the wall's yardage and the bin's count are both right.

Counting on a phone, bolt by bolt, in wall order.

The job Inventory sheet In TaroStack
Yards left on a bolt True at the yearly count Down with every cut recorded
Kits I can still cut Unroll the shortest bolt What could I make right now
Which bolt a kit came from A note On the batch record
Bolt ends A guess in the bin Counted as remnant stock

Stock, lots and recipes are on every plan. Starter holds 50 items, so a shop with a wall of bolts 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 quilt shops keep track of inventory?

Bolts by the yard, one row a print; precuts, notions and kits by the each; and remnants as their own row once a bolt is under a yard.

How do you measure fabric left on a bolt?

Count folds for a quick estimate, keep a running tally of cuts on the bolt end for accuracy, and unroll and measure at the full count.

How many kits can I make from a bolt?

Divide each bolt's yardage by what one kit takes from it. The smallest answer across the kit's fabrics is the number you can cut.

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.