Pool Supply Inventory Spreadsheet
For pool supply stores and pool service companies tracking chlorine, balancers, filters and pump parts. Handle the summer rush without running out of shock on a holiday weekend.
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| PO-TAB-3IN-25 | 3 in. Chlorine Tablets, 25 lb | Sanitizers | Chem Room / Shelf A | bucket | 30 | 12 | 64 | auto | auto | Aqua Clear Distributors |
| PO-PH-DN-10 | pH Decreaser, 10 lb | Balancers | Chem Room / Shelf C | bag | 18 | 8 | 11.5 | auto | auto | Aqua Clear Distributors |
| PO-CRT-C4950 | Filter Cartridge 50 sq ft | Filters | Parts Wall | each | 7 | 3 | 28.4 | auto | auto | Bluewave Pool 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
- Stock chlorine tabs and shock by the pallet before Memorial Day and let reorder points drop after Labor Day.
- Store oxidizers away from acids and note that storage location in the sheet so staff know where each belongs.
- Track filter cartridges by dimensions and model fit; customers often bring in the old one to match.
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