InkSheet Studio
Custom Apparel Pricing and Order Tracker Spreadsheet | Per-Method Quote Calculator, Deposit and Order Board - Google Sheets
Custom Apparel Pricing and Order Tracker Spreadsheet | Per-Method Quote Calculator, Deposit and Order Board - Google Sheets
Couldn't load pickup availability
INSTANT DOWNLOAD — HOW IT WORKS: This is a digital download, not a physical product — nothing is shipped. After checkout, your download link appears right on the confirmation page and is also emailed to you. Use the files in your favorite apps and projects, or print the PDF files at home or at a local print shop.
Still guessing what to charge per shirt?
Every decorator has a method they price from memory: a screen print number that worked in 2022, a DTF price copied from a competitor, an embroidery quote that forgot the digitizing fee entirely. This tracker ends the guessing. Set your real rates once — setup per color, print price by quantity, DTF per square inch, embroidery per thousand stitches, your markup on each method — and every quote prices itself the same honest way: garment, decoration, spoilage, markup. Then the quote flows into an order board that tracks the deposit, the balance and the due date, and finished jobs land on a profit dashboard that shows which method actually makes you money.
Transparency note: this spreadsheet was designed with AI assistance, then hand-built and formula-tested by our shop.
WHAT'S INSIDE — 8 focused tabs:
- Start Here — a plain-English guide and quick-start steps
- Dashboard — order pipeline counts, money on the board, a profit snapshot, and alerts (overdue orders, garments to reorder)
- Pricing Setup — every rate the calculator uses: screen print setup and quantity tiers, DTF per square inch, embroidery per 1,000 stitches with minimum and digitizing fee, vinyl flat per garment, plus your markup per method, spoilage allowance and deposit %
- Quote Builder — the live calculator: garment cost, quantity and method in, and out comes your cost, the quote, your profit and margin, the deposit due and the balance — for any of the four methods
- Order Board — every order from Quoted to Deposit Paid to In Production to Ready to Picked Up, with balance due calculating itself and OVERDUE / DUE SOON flags that fire on their own
- Garment Inventory — blanks on hand, reserved for open orders, available, and REORDER / OUT OF STOCK flags before a stockout costs you a deadline
- Job Log — finished jobs with the price you charged and what the job actually cost
- Profit Dashboard — margin by method and a monthly P&L, built from your finished jobs
HOW IT WORKS
1. After checkout you get a PDF with your private link. Click it and choose "Make a copy" — the tracker is yours.
2. Set your rates once on Pricing Setup. A few minutes, once — and every quote after that reads from your numbers.
3. Price the job on Quote Builder, put the accepted quote on the Order Board, take the deposit, and move the status as you work it. Log the finished job and the Profit Dashboard keeps score.
THE MATH, PLAIN AND SIMPLE
Quote = (garment cost + decoration cost) with your spoilage allowance added, marked up by that method's markup %. Screen print decoration is a setup fee per color plus a per-garment print price that drops as quantity rises. DTF prices by the square inch. Embroidery prices per 1,000 stitches with a per-garment minimum, plus digitizing once per design. Vinyl is one flat price per garment. In the pre-filled sample, 48 navy tees with a 2-color screen print price out at $788.48 on a $563.20 cost — $225.28 of profit, a 28.6% margin, and a $394.24 deposit due. Change the method or the quantity and it all re-prices.
WHY THIS ONE
Most apparel pricing tools are a calculator and nothing after: you get a number, then the order goes back to sticky notes and memory. This one runs the whole life of the job — quote, deposit, production board, garment reorder flags, and realized profit per method — in one Google Sheets file for a one-time price. It comes loaded with fictional sample data (10 finished jobs, 10 orders at every stage, one flagged overdue) so you can watch every formula work before you replace the samples with your own shop.
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.
REQUIREMENTS: a free Google account. Your tracker lives in Google Sheets — no Excel needed, and it works in the shop, at the press, and on your phone.
This is a digital product — no physical item will be shipped, and all sales are final (we can't accept returns or cancellations on digital downloads). Your files are available instantly after checkout. But don't worry: if anything isn't working right, message us anytime and we'll fix it for you — no time limit.
Share
