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.
