Cell Phone Repair Parts Inventory Template
For phone and tablet repair shops tracking screens, batteries, charging ports and adhesives by device model. Know which screens you have before quoting a same-day fix.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| PR-SCR-IP13-AM | iPhone 13 Screen Assembly (aftermarket) | Screens | Parts Cabinet / Drawer 2 | each | 3 | 2 | 42 | auto | auto | Pocket Parts Supply |
| PR-BAT-GS22 | Galaxy S22 Replacement Battery | Batteries | Parts Cabinet / Drawer 5 | each | 4 | 2 | 15.5 | auto | auto | Pocket Parts Supply |
| PR-ADH-B7000 | B-7000 Adhesive, 15 ml | Consumables | Bench 1 | tube | 6 | 3 | 3.2 | auto | auto | FixRight Tools & Parts |
ƒ = 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
- List each part by exact model and quality grade (OEM pull vs. aftermarket) since prices and warranty terms differ.
- Stock to repair volume: keep two or three screens for the most-repaired models, and order the rest on demand.
- Track defective parts returned to the supplier so RMA credits don't get lost.
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