Sublimation Business Profit Tracker Spreadsheet | Blanks Inventory, Design Profit and Misprint Cost - Google Sheets

One in twelve prints ruins a $6.50 blank. Price like it never happens, and the math eats your margin.

Most sublimation costing tools price a print. This one runs the back office: a blanks inventory with reorder flags, a design catalog that ranks every design by TRUE profit — after channel fees and after the blanks its misprints ruined — a per-print cost calculator with the misprint allowance built in, sales by channel, and a monthly P&L. Not a quote calculator and not an order board: this is the production economics of a sublimation shop.

WHAT THE SAMPLE DATA SHOWS

The tracker comes loaded with a fictional sample shop, Pressed With Pride (Sep–Oct 2026), and the samples make the point better than we can: the best-SELLING design, Sunflower Mama, sold 120 tumblers for the most revenue in the shop — and is NOT the most profitable. It ruined 36 of its 156 prints (23.1%), and once those blanks are counted it keeps $1,166.60. Retro Groovy Wave sold only 88 tumblers with just 4 misprints and keeps $1,256.20 — the most profit in the shop. Per unit it's the same story: Custom Pet Portrait keeps $22.75 a unit, Bee Kind keeps $6.55. On the shelf, the 20oz tumbler blank flags REORDER at 6 on hand, and $130.50 of wine tumblers sit as dead stock — no design uses them.

WHAT'S INSIDE — 7 TABS

1. Start Here + Dashboard — the full guide, your two settings (press-time labor rate, target margin), the money at a glance (units, attempts, misprint rate, net revenue, design profit, stock and dead-stock value), and the design profit board.

2. Blank Inventory — every blank you stock: landed cost each, stock on hand, reorder point, stock value, prints used, and status flags that fire themselves (REORDER / OUT OF STOCK).

3. Design Catalog — every design: the blank it prints on, ink/paper per print, press minutes, misprints logged — then units sold, attempts, misprint rate, cost per attempt, revenue after fees, production cost, and true profit per design, per unit, and margin.

4. Print Cost Calculator — the hero: blank + ink/paper + press time = cost per attempt; divide by the prints that survive and you get the TRUE cost per good print, plus the price at your target margin and the margin at the price you charge.

5. Sales Log by Channel — every sale (Etsy, market, social, custom order) with that channel's fee percentage taken out and the design's production cost already inside each row.

6. Expenses — overhead only: booth fees, software, equipment, packaging, marketing. Print costs do NOT go here — they're already counted per design.

7. Profit Dashboard — the podium (best seller, most profit, best per unit), profit by channel with fees out, blanks and dead stock at a glance, and the monthly P&L.

HOW THE MATH WORKS

Every attempt costs money, sold or trashed: cost per attempt = blank cost + ink/paper + press time (minutes × your labor rate). Attempts = units sold + misprints logged. Production cost per design = attempts × cost per attempt — so a design's profit already includes every blank it ruined. True cost per good print = cost per attempt ÷ (1 − misprint rate); at the samples' 11.8% shop rate, a $9.35 print really costs $10.60 per good one, and the price at a 55% margin is $23.56. Channel fee percentages are editable estimates (samples: Etsy 12%, Market 0%, Social 3%, Custom Order 0%) — set them to what your channels actually take.

WHO IT'S FOR

Sublimation sellers running a catalog — tumblers, mugs, shirts, signs — on Etsy, at markets, and through social or custom orders, who buy blanks in bulk and price by feel. It is an organization and calculation tool: it reports the numbers you enter, and it is not tax, financial, or legal advice.

You need a free Google account to use the Google Sheets file. Sample data is fictional and clearly replaceable — swap in your blanks, your designs, and your sales as you go.

FINISHED FILE — This listing is a digital item, delivered instantly as a file at checkout. The file is finished and ready to use — nothing is customized or personalized. If anything ever breaks or a formula misbehaves, message us and you will receive a corrected file free — forever, no time limit.

Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.

This is a digital product — no physical item will be shipped. Your file is available instantly after checkout. All sales are final (no returns or cancellations on digital downloads), but if anything is ever wrong with your file, message us anytime and we'll fix it — no time limit.