Auto Parts Inventory Template
Built for independent auto parts counters and repair shops that stock filters, brake pads, belts and fluids across dozens of makes. Track part numbers, bin locations and reorder points so the fast movers never leave a bay waiting.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| AP-BRK-1042 | Ceramic Front Brake Pad Set | Brakes | Aisle 3 / Bin 14 | set | 18 | 6 | 34.5 | auto | auto | Midwest Auto Supply Co. |
| AP-FLT-0217 | Oil Filter (spin-on, 3/4-16) | Filters | Aisle 1 / Bin 02 | each | 64 | 24 | 4.25 | auto | auto | Keystone Parts Distributors |
| AP-BLT-0880 | Serpentine Belt 6K880 | Belts & Hoses | Aisle 5 / Bin 31 | each | 9 | 4 | 22.8 | auto | auto | Midwest Auto Supply Co. |
ƒ = 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
- Store the OEM cross-reference number in the item name so counter staff can match aftermarket parts to the customer's VIN lookup.
- Raise reorder points on wipers, batteries and coolant ahead of seasonal swings instead of keeping them flat all year.
- Count cores and returns separately so warranty credits from suppliers don't inflate your on-hand quantity.
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 TemplateHardware Store Inventory SpreadsheetClothing Boutique Inventory TemplateConvenience Store Inventory SpreadsheetGift Shop Inventory TemplateBookstore Inventory SpreadsheetPet Store Inventory TemplateFlorist Inventory TemplateJewelry Store Inventory Spreadsheet