Screen Printing Inventory Spreadsheet
For screen printers and custom apparel shops stocking blank tees, plastisol inks, emulsion and screens. Track blanks by style, color and size so orders don't stall waiting on a missing XL.
Works in Excel, Google Sheets (File → Import) and Numbers. No sign-up.
| SKU | Item | Category | Location | Unit | Qty on Hand | Reorder Point | Unit Cost | Stock Valueƒ | Statusƒ | Supplier |
|---|---|---|---|---|---|---|---|---|---|---|
| SC-TEE-BLK-L | Ringspun Tee, Black, L | Blanks | Blank Shelf 1 | each | 72 | 36 | 2.95 | auto | auto | Threadhouse Blank Apparel |
| SC-INK-PL-WHT | Plastisol Ink, Low-Cure White | Inks | Ink Room | gal | 3 | 1 | 68 | auto | auto | Inkcraft Print Supply |
| SC-EMU-DC-QT | Dual-Cure Emulsion, Quart | Screen Prep | Darkroom | quart | 4 | 2 | 32 | auto | auto | Inkcraft Print Supply |
ƒ = calculated automatically by formula.
What's included
- SKU
- Item
- Category
- Location
- Unit
- Qty on Hand
- Reorder Point
- Unit Cost
- Stock Value — calculated automatically
- Status — calculated automatically
- Supplier
Tips for using this template
- Keep a small buffer of the top three blank colors in S through XL; most rush orders come from those.
- Weigh ink buckets at each count and track in pounds so partial gallons don't get written off as full.
- Log reclaimed vs. new screens separately, since emulsion and reclaim chemicals depend on how many screens you burn each week.
Stop typing deliveries by hand
Every time stock arrives you have to copy the supplier invoice into your sheet. Upload the invoice or packing slip to our invoice to inventory converter and paste SKU, item, quantity and unit cost straight into this template.
More free templates
Small Business Inventory TemplateRestaurant Inventory TemplateReseller Inventory SpreadsheetRetail Store Inventory TemplateWarehouse Inventory TemplateHome Inventory TemplateBar & Liquor Inventory TemplateOffice Supplies Inventory TemplateAuto Parts Inventory TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory Template