39 free Excel templates
Inventory & purchasing templates
Count what you have, see what is running low, and know what to reorder. Inventory sheets flag items at or below your reorder point and value stock at cost; purchasing sheets total supplier orders line by line so you can check them against the invoice when the delivery arrives.
Before you start
- The low-stock flag is only as good as your reorder levels: set them from real weekly usage.
- Count at the same time each week, before deliveries arrive.
- Use the dropdowns for categories and suppliers so totals group correctly.
Inventory & purchasing templates
Apartment Locator
Apartment Listing Inventory
A free listing inventory for apartment locators: track properties by area, rent, and commission with availability notes in Sheets or Excel.
Calculates commission $ · Tabs: Listings, Summary
Aquarium Store
Aquarium Livestock Inventory
A free livestock inventory for aquarium stores: track fish and coral by species and tank with cost, price, and loss flags in Sheets or Excel.
Calculates margin, stock value · Tabs: Livestock, Summary
Aquarium Store
Aquarium Store Supplier Order Sheet
A free supplier order sheet for aquarium stores: track livestock and dry-goods orders by supplier with received status in Sheets or Excel.
Calculates line total · Tabs: Order lines, Summary
Art Class Studio
Art Studio Supplies Inventory
A free supplies inventory for art studios: track paint, canvas, and materials by category with reorder points in Sheets or Excel.
Calculates cost per class, classes left, stock status, stock value · Tabs: Supplies, Summary
Auto Parts Store
Auto Parts Supplier Order Sheet
A free supplier order sheet for auto parts stores: track orders by supplier with quantity, cost, and received status in Sheets or Excel.
Calculates line total · Tabs: Order lines, Summary
Bar & Nightclub
Bar Inventory
A free bar inventory spreadsheet: track bottle counts, usage, and variance between counts to catch shrinkage and over-pours, in Google Sheets and Excel.
Calculates usage, variance, variance $, order to par · Tabs: Bottle count, Summary
Beauty & Cosmetology School
Beauty School Kit Inventory
A free kit inventory for beauty schools: track kit items by program with issued, on hand, and reorder points in Google Sheets or Excel.
Calculates kit cost, stock status, stock value · Tabs: Kit items, Summary
Brake Shop
Brake Parts Inventory
A free parts inventory for brake shops: track pads and rotors by fitment with reorder points and margin in Google Sheets or Excel.
Calculates stock status, stock value · Tabs: Parts, Summary
Coffee Shop
Cafe Inventory
A free cafe inventory spreadsheet: track beans, milk, and supplies with par levels, reorder points, and value totals, in Google Sheets and Excel.
Calculates order qty, stock value · Tabs: Inventory, Summary
Photography
Camera Gear Inventory
A free camera gear inventory spreadsheet: catalog serials, value, and warranty for insurance with total kit value, in Google Sheets and Excel.
Tabs: Gear, Totals
Cleaning Business
Cleaning Supplies Inventory
A free cleaning supplies spreadsheet: track stock with reorder alerts and cost-per-use to price into jobs, in Google Sheets and Excel.
Calculates cost per use, stock status, stock value · Tabs: Supplies, Summary
Shoe Repair & Cobbler
Cobbler Materials Inventory
A free materials inventory for cobblers: track soles, heels, leather, and supplies with low-stock flags in Google Sheets or Excel.
Calculates stock status, stock value · Tabs: Materials, Summary
Consignment Shop
Consignment Inventory
A free consignment inventory spreadsheet: track items, consignor, price, days on floor, and status with markdowns, in Google Sheets and Excel.
Calculates days on floor, current price, consignor payout · Tabs: Items, Summary
Land Development
Development Lot Inventory
A free lot inventory for land developers: track lots by phase and size with price, status, and absorption in Google Sheets or Excel.
Calculates list price, price per acre · Tabs: Lots, Summary
Equipment Rental
Equipment Rental Inventory
A free equipment rental inventory spreadsheet: track out vs. available, due-back dates, and utilization per unit, in Google Sheets and Excel.
Calculates revenue ytd, utilization, payback · Tabs: Units, Fleet summary
Event Rental
Event Rental Inventory
A free event rental inventory spreadsheet: track available vs. rented-out by date with quantity, value, and damage flags, in Google Sheets and Excel.
Calculates available, fleet value · Tabs: Inventory, Summary
Fabric & Quilting Store
Fabric Bolt Inventory
A free bolt inventory for fabric stores: track bolts by collection and supplier with yards on hand and price per yard in Sheets or Excel.
Calculates margin, stock status, stock value · Tabs: Bolts, Summary
Hardwood Flooring Installer
Flooring Material Order Log
A free material order log for flooring installers: list species and grade by square foot with waste and delivery dates in Sheets or Excel.
Calculates boxes, material cost · Tabs: Orders, Summary
Coffee Roaster
Green Coffee Inventory
A free green coffee spreadsheet: track lots by origin with weight on hand, cost, and reorder points in Google Sheets and Excel.
Calculates roasted cost per lb, stock status, stock value · Tabs: Green lots, Summary
Small Business
Inventory Tracker
A free inventory spreadsheet with low-stock alerts and auto-calculated stock value for Google Sheets and Excel. Stop overstocking and reordering late.
Jewelry Store
Jewelry Inventory
A free jewelry inventory spreadsheet: track cost, retail, margin, and memo status per item with aging for jewelers, in Google Sheets and Excel.
Calculates margin, days in stock · Tabs: Pieces, Totals
Kitchenware Store
Kitchenware Supplier Order Sheet
A free supplier order sheet for kitchenware stores: track brand orders by SKU with quantity, cost, and received status in Sheets or Excel.
Calculates line total · Tabs: Order lines, Summary
Med Spa
Med Spa Inventory
A free med spa inventory spreadsheet: track product stock, reorder points, expiry, and value for retail and consumables, in Google Sheets and Excel.
Calculates days to expiry, stock status, stock value · Tabs: Products, Summary
Pawn Shop
Pawn Shop Inventory
A free pawn inventory spreadsheet: track forfeited and bought items with cost, retail, margin, and aging for pawnbrokers, in Google Sheets and Excel.
Calculates margin, days on shelf · Tabs: Items, Summary
Auto Performance Shop
Performance Parts Inventory
A free parts inventory for performance shops: track high-value parts by supplier with cost and reorder points in Google Sheets or Excel.
Calculates available, stock status, stock value
Ear Piercing Studio
Piercing Jewelry Inventory
A free jewelry inventory for ear-piercing studios: track pieces by gauge and material with cost, price, and low-stock flags in Sheets or Excel.
Calculates margin, stock status, stock value · Tabs: Jewelry, Summary
Paint Protection Film
PPF Film Inventory Log
A free film inventory log for PPF shops: track rolls by brand and supplier with feet-used and reorder points in Google Sheets or Excel.
Calculates cost per ft, film cost per job, stock value, stock status · Tabs: Film, Summary
Radiator & Cooling Shop
Radiator Core Inventory
A free core inventory for radiator shops: track cores by vehicle application and supplier with reorder points in Google Sheets or Excel.
Calculates stock status, stock value · Tabs: Cores, Summary
Cabinet Refacing
Refacing Door & Material Order
A free door order log for cabinet refacing: list doors by style and size with veneer and hardware counts in Google Sheets or Excel.
Calculates line total · Tabs: Order lines, Summary
Computer Repair
Repair Parts Inventory
A free repair parts inventory spreadsheet: track on-hand parts, reorder points, cost, and supplier with value totals for shops, in Sheets and Excel.
Calculates stock status, stock value · Tabs: Parts, Summary
Boutique Retail
Retail Purchase Order
A free retail purchase order spreadsheet: track orders by vendor and item with cost and received status plus open-order totals, in Google Sheets and Excel.
Calculates line total · Tabs: Order lines, Summary
Salon & Beauty
Salon Product Inventory
A free salon inventory spreadsheet: track back-bar and retail products with reorder alerts and retail margin in Google Sheets and Excel.
Calculates margin, stock status, stock value · Tabs: Products, Summary
Shoe Store
Shoe Store Size Matrix Inventory
A free size-matrix inventory for shoe stores: track styles by size and width with gap flags and reorder-by-size in Sheets or Excel.
Calculates pairs on hand, core sizes out · Tabs: Size matrix, Gaps
Shoe Store
Shoe Store Supplier Order Sheet
A free supplier order sheet for shoe stores: track brand orders by style and size run with received status in Google Sheets or Excel.
Calculates line total · Tabs: Order lines, Summary
Siding Contractor
Siding Material Order Log
A free material order log for siding contractors: list product and trim by square with waste factor and delivery dates in Sheets or Excel.
Calculates order qty, line cost · Tabs: Materials, Summary
Day Spa
Spa Retail Inventory
A free spa retail inventory spreadsheet: track retail and back-bar product with reorder points, cost, margin, and value, in Google Sheets and Excel.
Calculates margin, stock status, stock value · Tabs: Products, Summary
Tattoo Studio
Tattoo Supply Inventory
A free tattoo supply inventory spreadsheet: track inks, needles, and consumables with reorder points, cost, and value, in Google Sheets and Excel.
Calculates stock status, stock value · Tabs: Supplies, Summary
Tool & Equipment Rental
Tool Rental Inventory
A free tool-rental inventory: track availability, daily rate, who has each item, and due-back dates in Google Sheets and Excel.
Calculates weekly discount · Tabs: Tools, Status board
Urgent Care Clinic
Urgent Care Supply Inventory
A free supply inventory for urgent care: track supplies by category against par levels with expiration and low-stock flags in Sheets or Excel.
Calculates order to par, days to expiry, stock status, stock value · Tabs: Supplies, Summary