Custom Apparel Tracker

Still guessing what to charge per shirt? Every decorator prices from memory: a screen print number from 2022, a DTF price copied from a competitor, an embroidery quote that forgot the digitizing fee. This tracker ends the guessing. Set your rates once — setup per color, print price by quantity, DTF per square inch, embroidery per thousand stitches, vinyl per garment, markup per method — and every quote prices itself this way: garment, decoration, spoilage, markup. Across 8 tabs, the quote flows to an Order Board tracking deposit, balance and due date with self-firing OVERDUE flags; garment inventory warns before a stockout costs a deadline; jobs land on a Profit Dashboard showing which method makes you money.

The sample quote: 48 tees, 2-color screen print — $788.48 on a $563.20 cost, $225.28 profit, 28.6% margin, $394.24 deposit due. Method margins run 28.6% to 37.5% (vinyl); 10 jobs total $7,783.10 revenue, $2,453.57 profit, with $5,942.87 of orders on the board.

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

What you receive is the finished file, delivered instantly at checkout as a PDF containing your Google Sheets copy link. Open it, choose "Make a copy," and the file is yours. It runs in Google Sheets on a free Google account — nothing to install — and sample data is included so you can see the formulas work. If a file ever breaks, you receive a corrected copy of the file free. This is a digital product — no physical item will be shipped.