Free Inventory Management Template for Excel (2026)

Before you invest in inventory management software, a well-built spreadsheet can take you surprisingly far. For startups and early-stage product businesses with under 100 SKUs and a single warehouse, an Excel or Google Sheets template covers the basics: what you have in stock, when to reorder, what's on order, and what it's all worth.

This guide gives you everything you need to build a robust inventory tracking spreadsheet from scratch—including the exact formulas, tab structure, and automation logic that make the difference between a useful system and an abandoned one. We'll also be honest about where spreadsheets break down, so you can make an informed decision about when to upgrade.

What a Good Inventory Template Actually Needs

Most free inventory templates you find online are underwhelming. They track current stock and maybe a reorder point, but they don't help you make decisions or catch problems before they become expensive. A genuinely useful inventory template should include:

• Product master data: All SKUs, descriptions, categories, units of measure, and supplier information in one place
• Current stock levels: Accurate, up-to-date quantities by location
• Inventory valuation: The total value of your current stock (crucial for financial reporting and purchasing decisions)
• Reorder logic: Automatic flags when stock falls below the reorder point
• Purchase order tracking: What's on order, expected delivery dates, and whether POs are on time
• Sales tracking: Units sold by SKU by period (weekly or monthly)
• Demand forecasting: A simple projection of when you'll run out at current sales velocity
• Supplier directory: Contact information and lead times for each supplier

If your template has all eight of these, you've built something genuinely useful. Most free templates online cover two or three.

How to Structure Your Spreadsheet: Tab by Tab

Tab 1: Product Master

This is the foundation. Every other tab references this one. Columns:

• SKU: Your unique product identifier (e.g., PRDT-001-BLU-LG)
• Product Name: Readable description
• Category: Product category for filtering and analysis
• Unit of Measure: Each, pair, case, box, kg, etc.
• Supplier: Primary supplier name (linked to Supplier Directory tab)
• Unit Cost: Your landed cost per unit
• Retail Price: Your selling price (or standard wholesale price)
• Target Margin: Your target gross margin for this SKU
• Actual Margin: =((Retail Price - Unit Cost) / Retail Price) — auto-calculated
• Barcode/UPC: For scanning workflows
• Status: Active, Discontinued, Seasonal

Keep this tab clean and treat it as your single source of truth for product information. Any change to a product starts here.

Tab 2: Stock Levels

This is your live inventory view. Columns:

• SKU: Linked to Product Master
• Product Name: Auto-populated from Product Master with VLOOKUP
• Opening Stock: Stock at the start of the current period
• Units Received: New inventory received this period
• Units Sold: Units sold/dispatched this period
• Adjustments: Manual corrections (e.g., after a stock count)
• Closing Stock: =Opening Stock + Units Received - Units Sold + Adjustments
• Reorder Point: The level at which you trigger a new order
• Safety Stock: Your buffer stock
• Reorder Flag: =IF(Closing Stock <= Reorder Point, "REORDER", "") — highlights in red when triggered
• Days of Cover: =Closing Stock / (Units Sold / Days in Period) — shows how many days until stockout at current pace
• Stock Value: =Closing Stock × Unit Cost

The key formula: Reorder Flag

This formula is the engine of your inventory tracking. When Closing Stock drops to or below Reorder Point, the cell turns red and shows "REORDER." Add conditional formatting: select the Reorder Flag column, set a rule to highlight in red when the cell equals "REORDER."

This transforms your spreadsheet from a passive tracker into an active alert system.

Tab 3: Purchase Orders

Track every outstanding purchase order here. Columns:

• PO Number: Your unique PO identifier
• Supplier: Who you ordered from
• SKU: What you ordered (one row per SKU per PO)
• Qty Ordered: How many units
• Unit Cost: Agreed unit cost on this PO
• Total Value: =Qty Ordered × Unit Cost
• Order Date: When the PO was placed
• Expected Delivery: Supplier's promised delivery date
• Status: Open, Partial, Received, Cancelled
• Days Overdue: =IF(Status="Received","",MAX(0, TODAY()-Expected Delivery))
• Overdue Flag: =IF(Days Overdue>0,"OVERDUE","")

Why PO tracking matters

Many spreadsheet users track current stock carefully but ignore what's on order. This leads to phantom stockouts—you see that stock is low, panic, and place another order, only to find out you already have an order in transit. Maintaining an accurate PO tracker prevents double-ordering and helps you answer the question "when will I have enough stock?" not just "how much do I have now?"

Tab 4: Sales Log

Track sales by SKU by period. For most small operations, weekly or monthly is sufficient. Columns:

• Date/Period: Week ending or month
• SKU: Product sold
• Units Sold: Quantity sold in this period
• Revenue: Units × Selling Price
• Channel: Where it sold (Shopify, wholesale, Amazon, etc.)

From the sales log, you can calculate:

• Average weekly/monthly demand per SKU (=AVERAGE of Units Sold column)
• Demand variability (=STDEV of Units Sold column / AVERAGE — your coefficient of variation)
• Best and worst performing periods
• Channel mix by SKU

Tab 5: Demand Forecast

Using your sales history, build simple forward-looking projections.

The simplest approach: 3-month rolling average demand by SKU.

• Average Monthly Demand: =AVERAGEIFS of last 3 months of sales for this SKU
• Months of Stock Remaining: =Closing Stock / Average Monthly Demand
• Projected Stockout Date: =TODAY() + (Months of Stock Remaining × 30)
• Urgency Flag: =IF(Months of Stock Remaining < 1.5, "URGENT", IF(Months of Stock Remaining < 3, "WATCH", "OK"))

Color-code by urgency: red for URGENT, yellow for WATCH, green for OK. This gives you a prioritized list of SKUs that need attention at a glance.

Tab 6: Supplier Directory

A simple reference table:

• Supplier Name
• Contact Name
• Email
• Phone
• Lead Time (days): Your actual lead time based on historical data, not quoted
• Payment Terms
• MOQ: Minimum order quantity
• Rating: 1-5 star rating based on reliability and quality
• Notes: Anything important (e.g., "closes for Chinese New Year," "requires 50% deposit")

Tab 7: ABC Analysis

This tab helps you prioritize your inventory management attention.

• Pull in SKU, product name, and annual revenue from your sales log
• Sort by annual revenue descending
• Calculate cumulative revenue and cumulative percentage of total
• Assign A/B/C category: A = top 80% of cumulative revenue, B = next 15%, C = final 5%

Use this to focus your safety stock, demand planning, and supplier management on the SKUs that drive the most revenue. Don't spend equal time managing your top seller and your slowest mover.

The Key Formulas You Need

Here are the most important formulas for an inventory spreadsheet, written for Excel/Google Sheets:

VLOOKUP to populate product details: =VLOOKUP(A2, ProductMaster!A:F, 2, FALSE) (Looks up SKU in column A of ProductMaster tab, returns value from column 2)

Days of cover: =IF(B2=0, "∞", C2/(D2/30)) (If no sales, infinite days; otherwise: closing stock / (monthly sales / 30))

Reorder flag with conditional formatting: =IF(C2<=E2, "REORDER NOW", "OK") (If closing stock <= reorder point, flag it)

Safety stock formula (simple version): =ROUND(1.65 STDEV(SalesHistory) SQRT(LeadTimeDays), 0) (For 95% service level; replace 1.65 with 1.28 for 90%)

Inventory turnover: =AnnualCOGS / AverageInventoryValue (Higher is better; target 4-8x for most product businesses)

Gross margin: =(RetailPrice - UnitCost) / RetailPrice (Express as percentage)

Automating Your Spreadsheet with Google Sheets Scripts

If you're using Google Sheets, you can add lightweight automation with Google Apps Script (no coding experience required for basic scripts):

Auto-email when reorder threshold is hit: You can write a simple script that checks for any "REORDER" flags each morning and sends you an email summary. Search "Google Sheets email script" for detailed tutorials.

Auto-timestamping receipts: When you update the Units Received column, a script can automatically record the date received in an adjacent column.

Scheduled refresh: If your sales data comes from a connected source (like a Shopify export), you can set up a daily auto-refresh of that data.

These aren't complex features—they're basic automations that save 15-30 minutes per week and reduce the risk of forgetting to check.

Common Inventory Spreadsheet Mistakes to Avoid

Mistake 1: Not updating it consistently A spreadsheet is only as good as the data in it. If you update stock levels weekly instead of daily, you'll frequently see inaccurate reorder flags. Build a habit or assign a specific person to own daily updates.

Mistake 2: Confusing "on hand" with "available" On hand is physical stock. Available is on hand minus what's already committed to open orders. If you have 100 units and 80 are already allocated to open sales orders, you only have 20 available to promise. Track allocated stock separately.

Mistake 3: Not tracking your adjustments Stock adjustments (corrections for miscounts, damage, shrinkage) should be logged with a reason code. This creates an audit trail and helps you identify patterns—for example, if one product has high shrinkage, you may have a theft or damage problem.

Mistake 4: Ignoring inventory on purchase orders "In transit" or "on PO" inventory affects your stock position. When making reorder decisions, consider what's already on order, not just what's on the shelf.

Mistake 5: Not reviewing the template regularly Business changes. New products, new suppliers, new channels. Review and update your template structure at least quarterly. An outdated template that doesn't reflect how you actually operate is just as useless as no template at all.