Skip to content

Sublimation Inventory Template: Blanks, Ink and Paper

A sublimation inventory template: blanks by type and case lot, ink by color with dates, paper and packaging, prints each bottle makes, 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

A sublimation shop mostly makes to order, so its stock isn't finished goods. It's blanks: coated mugs, tumblers, coasters and mouse pads waiting for a design. A sublimation inventory template counts each blank by type and size, with a reorder point, and keeps the case lot it came from, because coating varies between batches and a new case can press differently from the last. It counts ink by color, with the date on each bottle, since one empty color stops every job. And it lists paper, shrink wrap, tape and boxes. Below is a sheet filled in for a made-up shop, the sum for how many prints a bottle makes, and the file.

The short version

  • Blanks by type and size, counted in eaches.
  • Each case of blanks is a lot. Test a new lot before a big order.
  • Ink by color and bottle, with the maker's date.
  • Know how many prints a bottle and a pack of paper make.
  • Count misprints. They're blanks you paid for.
  • TaroStack takes the blank, paper and box off stock with each order you make. More below.

An example sheet

Item Unit On hand Reorder at Unit cost Value Status
Mug, 11 oz white, coated each 142 108 $1.45 $205.90 OK
Mug, 15 oz white, coated each 30 36 $1.95 $58.50 REORDER
Tumbler, 20 oz skinny each 58 50 $3.60 $208.80 OK
Sublimation paper, 8.5 x 11 sheet 310 200 $0.14 $43.40 OK
Ink, magenta, 140 mL bottle 1 1 $19.00 $19.00 REORDER
Mug boxes, single each 85 100 $0.48 $40.80 REORDER

Twelve rows in all, $832.60 of stock, with four to reorder: 15 oz mugs, magenta and black ink, and mug boxes.

What a bottle makes

Ink use depends on the design, so this is one shop's figure, worked out by counting.

A bottle of ink 140 mL
Full-wrap mug prints from a set of four bottles about 700
Ink cost a mug (four bottles at $19) about $0.11
Paper a mug (one sheet prints two wraps) $0.07

The useful part isn't the eleven cents. It's that colors don't run out together. This shop's designs lean on magenta and black, which is why those two are at their reorder point while cyan and yellow have a spare. Keep one unopened bottle of every color, and reorder when you open it. A reorder point of 1 on the sheet means exactly that.

Paper is simpler: 310 sheets at two mug wraps a sheet is 620 mugs, or 310 tumblers.

Blanks have lots

Received Item Case lot Quantity Note
Oct 14 Mug, 11 oz white 25-3381 144 4 cases of 36
Aug 2 Mug, 11 oz white 25-2907 36 Last case of the old lot: prints slightly warmer
Oct 30 Tumbler, 20 oz skinny T-1187 75 3 cases of 25
Sep 20 Ink, magenta INK-M-2409 2 bottles Use by Sep 2027

The coating on a sublimation blank is what takes the dye, and it isn't identical from one production run to the next. The note on the August case says it all: prints slightly warmer. On a single mug nobody would know. On an order of forty matching mugs, split across two case lots, the customer lines them up on a shelf.

So: press one test from every new case lot before using it for an order. Fill a matching order from one lot. And write the case lot on the order, so that a reorder in March can be matched, or the customer warned that it can't.

Ink has a date too. Old ink shifts color and can clog. The sheet flags a bottle USE FIRST inside 60 days of the maker's date.

Misprints

A ghosted wrap or a crooked design is a blank, a sheet of paper and some ink in the bin. Count them. This shop loses about one mug in twenty, which adds 7 cents to the cost of every good one and, more to the point, means an order of 40 needs 42 blanks on the shelf. A row on the count sheet for "misprints this week" is enough.

If the misprint rate jumps with a new case, that's the lot test you didn't do.

Pricing the finished pieces is in how to price tumblers. Shirts are counted by size as well as type, in t-shirt inventory template, and the sums for a shop are in sublimation business plan.

Get the template

Download the sublimation inventory template. Four sheets: inventory with value and REORDER, lots with days left for ink, 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

Every order takes a blank, a sheet of paper, a little of four inks, a shrink sleeve and a box. Six rows change with each one. On a day of thirty orders nobody touches the spreadsheet, and the 15 oz mugs go from "REORDER" to "none" without the sheet noticing.

How TaroStack does it

TaroStack takes the parts off when you record what you made.

Each product is a recipe. One blank, a sheet of paper, a sleeve, a box. Record thirty mugs and thirty of each come off stock.

Blanks are lots. Each case is received with its lot. The batch record notes which case the mugs came from, automatically, so an order can be matched later.

"What could I make right now" says how many of a product the blanks, paper and boxes on hand allow, and which runs out first.

A reorder list in days of cover, with reorder points suggested from how fast things really go.

Misprints are adjustments with a reason, so the month's waste is a number.

The job Spreadsheet In TaroStack
Take off blank, paper, box Six rows an order Recorded with the batch
Which case lot went on this order A note On the batch record
What's about to run out Notice The reorder list
Misprints this month A tally Waste by reason

Ink by the millilitre is hard to track from a recipe, since designs vary: most shops count bottles instead, and so does the example. Stock, lots and recipes 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

What inventory does a sublimation business need to track?

Blanks by type and size, ink by color, sublimation paper, shrink wrap and tape, and packaging. Finished pieces are usually made to order.

How many prints does a bottle of sublimation ink make?

It depends on the design and the printer. Count your own: the example shop gets about 700 full-wrap mugs from a set of four 140 mL bottles.

Why do my sublimation blanks print differently?

Coating varies between production runs. Test one blank from each new case, and fill matching orders from a single case lot.

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.