Warehouse Inventory Spreadsheet

Stock control for a small warehouse or stockroom without software: type receipts and issues as they happen and the workbook keeps the on-hand quantity, the stock value, the reorder list and the month's movements. Built for 2,000 SKUs and 20,000 movement lines.

WHAT YOU GET

• Warehouse Inventory Tracker (Excel): Items (SKU, description, category, location, unit, unit cost, reorder point and quantity, supplier; received, issued, on hand, value and below-reorder flag calculate), Movements (date, reference, SKU, IN/OUT, quantity, location, by), Reorder list with suggested order quantity, Cycle count sheet with variance, Dashboard with KPI tiles, by category and by month with a chart, Start-here sheet
• Quick-start PDF

30,698 formulas, recalculated and checked for errors before listing. Units are whatever you use (each, box, roll, kg, lb).

HOW TO USE

1. Buy, then download on the page that opens right after payment (your Stripe receipt email carries the same link).

2. Open the workbooks in Excel 2016 or later, Google Sheets or LibreOffice; the quick-start PDF opens in any PDF app.

3. Yellow cells are inputs, grey cells calculate. Replace the example rows with your own.

PLEASE NOTE

• Digital download only; nothing is shipped. Returns are not possible on digital files; if a file will not open, email [email protected] and it gets fixed.
• Works in Excel 2016 or later, Google Sheets and LibreOffice; drop-downs and the chart included.
• Templates are not legal, tax or insurance advice. Have agreements reviewed by your own counsel and follow your own operating rules.
• For use in one business. Not for resale or redistribution.

Designed by A3E Studio (Ontario, Canada) and generated by our own software; every formula is recalculated and checked before listing.