Skip to content

Vinyl Inventory Spreadsheet: Rolls by the Foot

A free vinyl inventory spreadsheet for decal and shirt makers: adhesive and heat transfer vinyl by the foot, sheets, blanks, a reorder flag and a roll tally.

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

Vinyl comes on rolls, and a roll is never the number on its label for long. So a vinyl inventory counts feet left on each roll, one row for each type, color and finish: permanent or removable adhesive vinyl, heat transfer vinyl, glitter, metallic. Beside the rolls it counts sheets by the each, transfer tape by the foot, and the blanks the vinyl goes onto: tumblers, shirts, signs. Each row has a level to reorder at and a cost for one foot, so that a quote is based on what the material costs you and an order isn't accepted for vinyl you don't have. The hard part is knowing what's left on a roll without unrolling it, and the answer is a tally on the core. Below is a sheet for a made-up decal and shirt maker, the tally, and the file.

The short version

  • One row for each type, color and finish. Black matte permanent and black matte removable are two rows.
  • Count rolls in feet left. Sheets and blanks by the each.
  • Keep a tally on the roll's core: start length, minus each cut.
  • A reorder level in feet: what your biggest usual job takes, plus a margin.
  • Cost for one foot, so jobs can be priced.
  • TaroStack takes the vinyl off the roll when you record the job. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Permanent adhesive, black, matte, 12 in ft 38 15 $0.62 $23.56 OK
Permanent adhesive, gold, metallic, 12 in ft 6 10 $1.10 $6.60 REORDER
Heat transfer, white, 12 in ft 9 15 $1.35 $12.15 REORDER
Heat transfer, glitter rose gold, 12 x 20 in sheet 3 4 $3.90 $11.70 REORDER
Transfer tape, 12 in ft 55 30 $0.21 $11.55 OK
Tumbler, 20 oz, stainless, white each 16 12 $6.25 $100.00 OK

Twelve rows in all, $345.64 of stock. Three are flagged. Notice where the money is: $180 of it is tumblers and shirts. The blanks, not the vinyl, are most of what's tied up.

The tally on the core

Unroll a new roll against a tape measure once, or trust the label, and write the length inside the core or on a tag: "30 ft". Every time you cut, cross it out and write what's left.

Roll Start Cut Left
Gold metallic, bought Oct 20 30 ft 6 ft, tumbler order 24 ft
10 ft, wedding signs 14 ft
8 ft, test cuts and a misfeed 6 ft

At count time you read the cores. It takes ten minutes for a rack of rolls, and you never unroll anything.

The last line of that tally matters. Eight feet went to test cuts and a misfeed, a quarter of the roll. Waste is part of what vinyl costs, and a tally is the only place you'll see it.

Will the job fit?

A 24-decal order in gold, each decal 3.5 inches wide and 4 inches tall, on a 12 inch roll.

Decals across the roll (12 in wide, with margins) 3
Rows needed (24 ÷ 3) 8
Length a row (4 in tall, plus a gap) 4.5 in
Vinyl for the decals 3 ft
Lead-in, weeding border and a spare row 1 ft
Vinyl needed 4 ft

Four feet for this one. Now take a larger decal: 10 inches wide, one across, 24 rows of 4 inches, eight feet. Same count of decals, twice the vinyl. Work it out before you say yes, and check it against the tally, not the label on the roll.

Costing a job

Per decal
Gold vinyl, 4 ft at $1.10 ÷ 24 $0.18
Transfer tape, 3 ft at $0.21 ÷ 24 $0.03
Materials $0.21

Materials are small. Your time weeding and taping is the real cost, and it's the part people leave out. The full sum is in how to price vinyl decals, and for shirts and tumblers in how to price tumblers.

Blanks and sizes

Shirts are a size run: a row for each size, or you'll find you have 21 black shirts and no mediums. The same goes for tumbler colors. The layout for that is in t-shirt inventory template, and for dye-sublimation blanks in sublimation inventory template.

Offcuts

Pieces too small to go back on the roll and too big to bin go in a scrap box by color. They're not on the sheet. Use them for test cuts and small one-off jobs, and empty the box when it won't close.

Get the spreadsheet

Download the vinyl inventory spreadsheet. Four sheets: inventory with value and a REORDER flag, a lots sheet for rolls with what's been cut from each, a count sheet to print, 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 team order comes in: thirty shirts, two colors of heat transfer, names on the back. That's shirts in five sizes, white vinyl, black vinyl and a carrier sheet, all to take off the sheet by hand when the job's done, on a Friday night. It doesn't happen. The next order is quoted against numbers that are thirty shirts and nine feet out.

How TaroStack does it

TaroStack takes the materials off when the job is recorded.

A design is a recipe. A shirt, so many inches of white vinyl, so many of black. Record thirty made and the shirts and the vinyl go down by exactly that, with inches converted from feet on the roll.

Scrap is part of the recipe. Put a scrap percentage on the vinyl and misfeeds are allowed for.

"What could I make right now" says how many of a design your blanks and vinyl allow, and which runs out first.

The job's cost is real, from what that roll actually cost.

A reorder list in days of cover, so the gold is ordered before the order that needs it.

The job Spreadsheet In TaroStack
Take vinyl and blanks off after a job By hand, if you remember Record the batch
Is there enough for this order Read the cores, do the sum What could I make right now
What did the job cost Work it out The batch's cost
When to reorder A flag after a count The reorder list

Starter, at $9.99 a month, holds 50 items and 5 recipes. A range of designs and 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 vinyl inventory?

List each type, color and finish with the feet left on the roll, and keep a running tally on each roll's core, subtracting every cut.

How do I know how much vinyl is left on a roll?

Write the starting length on the core and subtract each cut as you make it. At count time, read the cores.

How much vinyl do I need for an order?

Work out how many designs fit across the roll's width, divide the order by that to get rows, multiply by the design's height plus a gap, and add a foot for lead-in and a spare.

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.