Google Sheets Inventory Template 2027 — Free & Premium Options

Why Use Google Sheets for Inventory?

For businesses with under 1,000 SKUs, Google Sheets provides everything you need at zero cost. Combined with Apps Script automation, it can match features of paid inventory software costing 500K–2M VND/month.

Essential Sheets in Your Inventory Template

1. Products Master: SKU, name, category, unit, cost price, selling price, reorder point
2. Stock Movements: Date, SKU, type (in/out), quantity, reference, notes
3. Current Stock: Live balance calculated from movements using SUMIFS
4. Suppliers: Contact info, lead times, payment terms
5. Purchase Orders: PO number, supplier, items, expected delivery
6. Low Stock Alerts: Items below reorder point, filtered automatically

Key Formulas for Inventory Tracking

=SUMIFS(Movements!D:D, Movements!B:B, A2, Movements!C:C, "IN") - SUMIFS(Movements!D:D, Movements!B:B, A2, Movements!C:C, "OUT")

This formula calculates current stock for any SKU by summing all IN movements minus all OUT movements.

Setting Up Reorder Alerts

Use conditional formatting to highlight low-stock items:

• Select the Current Stock column
• Apply conditional formatting: if stock < reorder point, highlight red
• Add an Apps Script trigger to email alerts when stock drops below threshold

Barcode Scanning Integration

Connect a USB barcode scanner to Google Sheets:

1. Create a "Scan Input" cell at the top of your movements sheet
2. Use VLOOKUP to auto-fill product details when a barcode is scanned
3. Press Enter to log the movement and clear for next scan

Multi-Warehouse Setup

Track multiple locations by adding a "Warehouse" column to your movements sheet. Use SUMIFS with both SKU and Warehouse criteria to get stock per location.

Get a ready-made multi-warehouse template at SheetStore Marketplace.

FAQ