Skip to content

T-Shirt Inventory Template: Every Size Is Its Own Row

A free t-shirt inventory template in Excel: blanks by color and size with a size curve, transfers by design, printed stock, dye lots, and reorder points.

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

In a t-shirt inventory, "heather grey tee" isn't an item. "Heather grey tee, large" is. Sizes don't substitute for each other, so every color and size gets its own row, its own count and its own reorder point. Those reorder points follow a size curve, because sizes don't sell evenly: for most adult lines, large sells about three times as fast as small or 2XL. The rest of the sheet depends on how you print. A shop that presses transfers counts transfers by design. One that prints to order holds blanks and almost no finished shirts. Below is a sheet for a made-up shop that presses transfers, the size curve worked out, and the file.

The short version

  • One row for each color and size.
  • Set reorder points on a size curve, from your own sales.
  • Count transfers or screens by design, apart from the shirts.
  • Hold blanks, not printed shirts, wherever you can.
  • Note the dye lot on each carton. "Heather grey" varies.
  • TaroStack takes the right size blank and the transfer off stock with each batch. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Blank tee, heather grey, S each 14 12 $3.40 $47.60 OK
Blank tee, heather grey, M each 22 24 $3.40 $74.80 REORDER
Blank tee, heather grey, L each 41 36 $3.40 $139.40 OK
Blank tee, heather grey, XL each 20 24 $3.40 $68.00 REORDER
Blank tee, heather grey, 2XL each 9 12 $4.90 $44.10 REORDER
Transfers, 'Summit' design each 18 50 $1.25 $22.50 REORDER

Twelve rows in all, $789.30 of stock, with five to reorder.

The size curve

This shop's sales of adult tees over three months:

Size Share of sales Out of every 12 Reorder point
S 10% 1 12
M 22% 2.5 24
L 32% 4 36
XL 23% 3 24
2XL 13% 1.5 12

The reorder points are a month of sales at about 110 shirts a month in this color. Order to the curve as well: a reorder of 144 grey tees is roughly 14, 32, 46, 33 and 19, not 29 of each. Ordering evenly is how a shop ends up with forty mediums and no larges.

Your curve is your own. Youth-skewed designs run small. Workwear runs large. Take three months of sales by size and divide.

2XL and up cost more a blank, here $4.90 against $3.40. Price for it, or accept it, but know it: see how to price t-shirts.

Blanks, not printed shirts

A blank can become any design. A printed shirt is that design, in that size, for good. Every printed shirt on the shelf is a guess about what someone will want.

Blank Printed
Can be sold as Any design in that color and size One design, one size
Rows to stock 5 sizes of 3 designs 5 15
If the design stops selling Nothing lost Clearance

So this shop keeps six printed larges of its best design for walk-ins and presses everything else to order from blanks and transfers. The transfer is the design in storable form: 64 'Trailhead' transfers can go on any size.

Dye lots and transfer dates

Received Item Order or run Quantity Note
Oct 21 Blank tee, heather grey, L PO 1188 72 Dye lot 5521
Sep 9 Blank tee, heather grey, 2XL PO 1162 24 Dye lot 5390: slightly lighter
Nov 3 Transfers, 'Trailhead' Run TR-1103 100 Best pressed within six months
Nov 12 Printed tee, 'Trailhead', grey, L TP-1112 12 Blanks PO 1188; transfers TR-1103

Heathers and garment-dyed colors shift between dye lots. A team order of twenty shirts across two lots shows two greys in the team photo. Fill a matching order from one lot, and check the carton label when it arrives.

Transfers age. This shop's printer says six months, after which they may not release cleanly. The sheet carries that as a use-by.

Mugs and tumblers are counted the same way, by blank, in sublimation inventory template. Listings that have to match the shelf are in Etsy inventory spreadsheet, and what a shirt business needs before selling in t-shirt business license.

Get the template

Download the t-shirt inventory template. Four sheets: inventory with value and REORDER, lots, a count sheet, and a read-me. Add a row for each color and size you carry. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.

Where this stops working

Three colors in five sizes is fifteen rows of blanks. Add two more colors and youth sizes and it's forty. Each order takes one blank from one of them and one transfer, and the online listing shows "in stock" for a design whether or not the large grey blank it needs is on the shelf.

How TaroStack does it

TaroStack ties each printed shirt to the exact blank it uses.

Each printed shirt is a recipe. One grey large blank, one 'Trailhead' transfer, a neck label, a mailer. Record a batch and those exact rows go down.

"What could I make right now" says how many 'Trailhead' larges you can press: the lower of the blanks and the transfers.

The batch notes the lots. Which carton of blanks and which transfer run, automatically.

Reorder points suggested from how stock moves. Each size gets its own, from its own sales, which is the size curve without the arithmetic.

A reorder list in days of cover, by size.

The job Spreadsheet In TaroStack
Take off the right blank Find the row The recipe names it
Can I press this order? Check two rows What could I make right now
Reorder points by size Work out the curve Suggested from sales
Which dye lot went on that order A note On the batch record

Starter holds 50 items and 5 recipes, which a shop with several colors and sizes outgrows quickly; Growth holds 3,000 items and 50 recipes. Stock, lots and recipes are on every plan, from $9.99 a month or $39 a month for Growth. 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 t-shirt inventory?

With a row for every color and size, a reorder point for each, and separate rows for transfers or printed stock by design.

What is a size curve?

The share of sales each size makes up. It tells you how to split an order: in the example, 10% small, 22% medium, 32% large, 23% XL and 13% 2XL.

Should I stock printed shirts or blanks?

Blanks, where you can print to order. A blank can become any design; a printed shirt can only be sold as what it is.

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.