Inventory Spreadsheet Template (Excel)
Free .xlsx inventory template with formulas and summary.
Products, Movements, Summary and Instructions
Short answer:download a free, ready-to-useExcel inventory template, with a products sheet (SKU, warehouse, minimum stock, cost, system quantity and counted quantity), formulas that calculate differences, inventory value and restock alerts, a movements sheet and an automatic summary.
Customize your warehouses and categories before downloading. The file is generated in your browser in .xlsx format and works in Excel, Google Sheets and LibreOffice.
When to use this tool
- If you track inventory by hand or in an unstructured Excel file.
- Before a physical count, to record differences.
- To organize SKUs, warehouses and opening inventory before migrating to a system.
- When you need to know which SKUs to restock.
How to use the inventory template
- 1Enter your warehouses and categories separated by commas.
- 2Choose how many product rows you need and whether you want sample rows.
- 3Download the file and record each product with a unique SKU.
- 4On each physical count, fill in the counted quantity: the difference is calculated automatically.
- 5Record each inflow, outflow or transfer in the movements sheet.
When Excel falls short
This same template is the starting point for moving to Katuq: with SKUs, warehouses and opening inventory organized, the upload is direct. In Katuq every order from WhatsApp, web, POS, Shopify or WooCommerce deducts inventory from the right warehouse, with unlimited warehouses on every plan.