Free Inventory Tracker Template for Excel (2026) — Movement-Driven, Reorder Alerts, ABC Analysis
TEMPLATE · BUSINESS · OPERATIONS

Free Inventory Tracker Template for Excel (2026)

A movement-driven inventory system with auto reorder alerts, a real-time dashboard, and a 25-SKU catalog pre-loaded across 5 categories. Every RECEIVE, ISSUE, and ADJUST logs once — and Current Stock, Stock Value, and Reorder Status update everywhere via SUMIFS. Built in Excel with 602 formulas across 6 sheets — zero setup, works offline, no add-ins.

Download the Inventory Tracker Template

Free .xlsx download — no email required. Opens in Microsoft Excel, Excel Online, Google Sheets, and LibreOffice Calc.

Download inventory-tracker-2026.xlsx

Excel 2007+ compatible · Also works in Google Sheets & LibreOffice

File size37 KB
Format.xlsx
LicenseFree — personal & commercial
Last updatedJanuary 2026
6Sheets included
602Live formulas
25SKUs pre-loaded
SUMIFSMovement-driven stock

Inventory Dashboard — the showpiece

A single-glance view of your entire operation. Five headline KPIs, an inventory-by-category breakdown, a movement summary for the current month, and a live "reorder now" watchlist — every number refreshes instantly as movements accumulate.

inventory-tracker-2026.xlsx — Inventory Dashboard
Inventory Dashboard
Snapshot · Jan 31, 2026 · 25 SKUs across 5 categories
Total SKUs25
Inv. Value$14,244
Low Stock5
Out of Stock2
Jan Moves73
Inventory by Category
CategorySKUsStockValue%
Office61,128$4,926.0030.7%
Packaging51,714$3,750.8523.4%
Electronics6365$3,196.6519.9%
Safety4277$2,116.7013.2%
Cleaning4417$2,073.0012.9%
TOTAL253,901$14,244100%
This Month's Activity
TypeCountValue
RECEIVE36$21,337
ISSUE36$5,306
ADJUST1$32
January73$26,675
Top Products Needing Reorder
SKUProductCurrentReorder PtStatus
ELEC-002Wireless Mouse−620OUT
SAFE-004Safety Glasses Clear−320OUT
SAFE-003First Aid Kit28LOW
OFFC-004Stapler Heavy Duty310LOW
PACK-001Bubble Wrap Roll 100ft1420LOW

Every tile is powered by SUMIFS, COUNTIF, or COUNTIFS against the Stock Movements sheet. Nothing is hard-coded — add movements and the dashboard follows.

Product Master — 25 SKUs with live stock

The Product Master holds one row per SKU with cost, price, reorder point, and supplier. Current Stock, Stock Value, and Status (OK / LOW / OUT) all auto-calculate — no manual updates when movements happen.

inventory-tracker-2026.xlsx — Product Master (excerpt)
SKUProductCat CostPrice Reorder Pt CurrentValue Status
ELEC-001USB-C Cable 6ftElectronics$4.20$12.9940123$516.60OK
ELEC-002Wireless MouseElectronics$11.50$29.9920−6−$69.00OUT
OFFC-003Copy Paper A4 500shOffice$4.80$10.9960460$2,208.00OK
OFFC-004Stapler Heavy DutyOffice$9.20$22.99103$27.60LOW
PACK-001Bubble Wrap Roll 100ftPackaging$8.90$19.992014$124.60LOW
SAFE-003First Aid KitSafety$16.40$39.9982$32.80LOW
… 19 more SKUs across Electronics, Office, Packaging, Cleaning, Safety

Current Stock formula: =SUMIFS(MoveQty,MoveSKU,B6,MoveType,"RECEIVE")+SUMIFS(MoveQty,MoveSKU,B6,MoveType,"ADJUST")−SUMIFS(MoveQty,MoveSKU,B6,MoveType,"ISSUE"). Status: =IF(J6<=0,"OUT",IF(J6<=G6,"LOW","OK")). Everything else is downstream of these two lines.

Stock Movements — every RECEIVE, ISSUE, ADJUST

One row per movement. Log the date, SKU, type, quantity, and reference — everything else propagates. Pre-filled with 73 sample entries across Jan 1–23, 2026 including opening balances, supplier receives, e-commerce fulfillment, and count adjustments.

inventory-tracker-2026.xlsx — Stock Movements (excerpt)
DateSKUType Product QtyValue Reference
Jan 1ELEC-001RECEIVEUSB-C Cable 6ft120$504.00OPEN-2026
Jan 3ELEC-001ISSUEUSB-C Cable 6ft22$92.40ORD-9142
Jan 5PACK-002RECEIVEShipping Box Medium500$425.00PO-2026-014
Jan 8OFFC-003RECEIVECopy Paper A4240$1,152.00PO-2026-016
Jan 10OFFC-002ADJUSTSticky Notes 3x35$32.00CNT-Q1-01
Jan 13ELEC-006ISSUEBluetooth Speaker15$283.50ORD-9268
Jan 17PACK-001ISSUEBubble Wrap Roll3$26.70DMG-2026-02
… 66 more rows across Jan 1–23, 2026

Grab the free Inventory Tracker — no strings.

Ready-to-use .xlsx · 6 sheets · 602 formulas · Movement-driven · Auto reorder alerts.

Download .xlsx

What's inside — 6 sheets

Six sheets, one clean flow: log every movement once, watch stock levels and reorder alerts update everywhere.

01Setup Guide

Welcome sheet with quick-start steps, RECEIVE/ISSUE/ADJUST movement legend, cell color legend, and a 60-second orientation. Read this first.

02Inventory Dashboard

Real-time snapshot: 5 KPI tiles, inventory by category, this month's activity, and the top reorder-needed products. All movement-driven.

03Product Master

25 SKUs across 5 categories with Cost, Sell Price, Reorder Point, Supplier, and auto-calc Current Stock + Stock Value + OK/LOW/OUT Status with color-coded conditional formatting.

04Stock Movements

The raw log — one row per RECEIVE, ISSUE, or ADJUST. 73 pre-filled entries across Jan 1–23, 2026. Dropdown validations on SKU and Type.

05Suppliers

6 vendor master rows with company, category, contact, phone, lead time (3–10 days), and payment terms.

06Reorder Report

Auto-flags every SKU at or below its reorder point with a Suggested PO quantity and matched supplier — filter by Status = LOW/OUT to generate this week's purchase orders.

Features

What separates this from a manual spreadsheet.

Σ

Movement-driven stock

Every stock level is a SUMIFS of the Stock Movements log. No double-entry. No "current stock" cell to forget to update.

⚠

Auto reorder alerts

Status column color-codes as OK / LOW / OUT the moment stock drops. Reorder Report generates suggested PO quantities per supplier.

📊

Real-time dashboard

Five KPI tiles + category breakdown + movement activity + reorder watchlist. Everything refreshes as you log.

🏷

25 SKUs pre-loaded

Electronics, Office, Packaging, Cleaning, Safety — a realistic starter catalog you can edit or replace entirely.

🚚

Supplier integration

Every product links to a supplier via SUP-ID. Reorder Report shows exactly who to call for each low-stock item.

📱

Works everywhere

Excel 365, 2021, 2019, 2016, 2013, 2010, 2007. Google Sheets. Excel Online. LibreOffice Calc. No add-ins.

Who this is for

Built for operations too small for NetSuite but too structured for pen-and-paper.

E-commerce operators

You fulfill Shopify or Amazon orders from your own warehouse. Log every outbound shipment as an ISSUE; the Reorder Report tells you what to buy this week to avoid stockouts.

Small warehouses & distributors

You receive from 5–15 suppliers and ship to B2B customers. The movement log doubles as your audit trail; the Suppliers sheet holds lead times for PO planning.

Office / facilities managers

You order office supplies, cleaning products, and safety gear for a company of 20–200. Categories map to your budget lines; reorder alerts prevent the "we ran out of toner" scramble.

Movement-driven inventory accounting

The single design decision that makes this template different from every "Current Stock" column you've ever maintained by hand.

Why a movements log beats a "Current Stock" cell

The common approach — one cell per SKU showing "how many we have right now" — is the source of every inventory disaster. Someone forgets to decrement it after a sale, a receive isn't logged, and by month-end the number on the sheet has nothing to do with reality. There's no audit trail, no way to answer "when did we run out?", no way to see how fast a product moves.

The alternative is a movements log: one row per event (RECEIVE / ISSUE / ADJUST), and Current Stock is a formula, not a cell you edit. This template uses the movements approach end-to-end.

Current Stock (SKU X) = SUMIFS(MoveQty, MoveSKU, "X", MoveType, "RECEIVE") + SUMIFS(MoveQty, MoveSKU, "X", MoveType, "ADJUST") − SUMIFS(MoveQty, MoveSKU, "X", MoveType, "ISSUE")

Three benefits that compound daily:

  • Perfect audit trail. Every stock change has a date, reference (PO / order / count sheet), and note. Trace any discrepancy back to the transaction that caused it.
  • Historical stock at any date. Change the filter on Movement Date and see stock as of any point in time — critical for month-end close and tax filings.
  • Impossible to under-count silently. If a movement isn't logged, Current Stock is wrong in a specific, findable way — not silently drifting. The dashboard KPIs catch anomalies fast.

The three movement types

TypeSignWhen to use
RECEIVE+ (adds)Purchase order arrival, opening balance, customer return, transfer in from another location.
ISSUE− (subtracts)Customer sale/fulfillment, internal consumption, damage write-off, transfer out to another location.
ADJUST+ (adds)Physical count reveals more stock than the log shows (positive adjustment). For negative adjustments, use ISSUE with a note like "count correction" or "damage."

Reorder point, safety stock, and EOQ

Three formulas that turn inventory from reactive firefighting into planned replenishment.

Reorder Point (ROP)

The stock level at which you must place a new order to receive it before you run out. It has two components: average usage during the supplier's lead time, plus a safety cushion.

Reorder Point = (Average Daily Usage × Lead Time in Days) + Safety Stock

Example: If USB-C cables sell 4 units/day, and TechDirect takes 7 days to deliver, and you want a 10-unit safety cushion:

  • Average daily usage: 4 units
  • Lead time: 7 days → expected usage during lead time = 28 units
  • Safety stock: 10 units
  • Reorder Point = 28 + 10 = 38 units

The template's Reorder Point column is manually entered so you can set it based on your own math. Set it too low → stockouts. Set it too high → cash tied up in shelves.

Safety Stock

Buffer against variability in demand and supplier lead time. The rigorous formula uses standard deviations:

Safety Stock = Z × σdemand × √Lead Time

Where Z is the service level factor (1.65 for 95% service level, 2.33 for 99%), and σdemand is the standard deviation of daily demand. For most small businesses, a simpler heuristic works:

  • Steady demand, reliable supplier: 3–5 days of average usage.
  • Variable demand OR unreliable supplier: 7–14 days of average usage.
  • Both variable: 14–21 days, and consider a second supplier.

Economic Order Quantity (EOQ)

How many units to order each time, balancing ordering cost (paperwork, receiving labor) against holding cost (warehouse space, insurance, obsolescence).

EOQ = √( (2 × D × S) / H ) D = Annual demand (units) S = Cost per order (fixed) H = Holding cost per unit per year

Example: 1,000 units/year demand, $50 fixed cost per PO, $2/unit/year holding cost:

  • EOQ = √((2 × 1000 × 50) / 2) = √50,000 ≈ 224 units per order
  • Number of orders per year = 1,000 ÷ 224 ≈ 4.5 (roughly quarterly)

The template's Reorder Qty column is manual — enter your EOQ result, or use a simpler rule like "2 months of average usage." Both approaches get you 80% of the way with 20% of the analysis.

FIFO, LIFO, or weighted average — which costing method?

When unit cost changes between purchases, which cost gets assigned to the item that just left your warehouse? Three answers, all IRS-compliant, with meaningfully different implications.

Method What it means Effect in rising prices Best for
FIFOFirst In, First Out. Oldest inventory is sold first.Lower COGS, higher profit, higher tax, higher ending inventory value.Perishables, style-driven products, most retail.
LIFOLast In, First Out. Newest inventory is sold first.Higher COGS, lower profit, lower tax, lower ending inventory value.Non-perishable commodities in inflationary environments. Not allowed under IFRS — US GAAP only.
Weighted AvgAverage of all unit costs, weighted by quantity.Smooths out spikes. Middle-of-the-road tax + profit outcomes.High-volume identical items (screws, resistors, uniform SKUs).

How this template handles cost

The Stock Movements sheet captures the actual Unit Cost of every RECEIVE — so you have the raw data for any costing method. The template ships with a single Unit Cost per SKU on Product Master (used for stock valuation), which effectively behaves like a weighted-average approach if you update the Cost to reflect your most recent PO.

For strict FIFO or LIFO, you'll want to layer costs — track lots or receipts separately. That usually means graduating to a light-inventory app (SOS Inventory, Cin7, or QuickBooks Enterprise Inventory) once your SKU count crosses ~200 or your accountant demands it.

ABC analysis — which SKUs actually deserve your attention

Not all inventory is equal. ABC analysis (a Pareto approach) classifies SKUs into three buckets by revenue or usage value. Manage the A items closely, the B items periodically, and the C items with the lightest touch.

A

High value, few SKUs

Roughly 20% of your SKUs generating 70–80% of revenue. Tight control: weekly counts, tight reorder points, no stockouts, multiple suppliers.

~20% SKUs / ~80% value
B

Medium value, medium SKUs

Roughly 30% of SKUs generating 15–20% of revenue. Standard control: monthly counts, formula-driven reorder points, moderate safety stock.

~30% SKUs / ~15% value
C

Low value, many SKUs

Roughly 50% of SKUs generating just 5% of revenue. Loose control: quarterly counts, generous safety stock, larger order batches to save PO overhead.

~50% SKUs / ~5% value

How to run ABC on this template

Add three columns to Product Master: Annual Revenue (SKU sell price × annual units sold), % of Total Revenue, and ABC Class. Then use this formula for the classification:

ABC Class: =IF( CumulativePct <= 0.80, "A", IF( CumulativePct <= 0.95, "B", "C" ) )

Sort by Annual Revenue descending, calculate running cumulative percentage, and apply the formula. Filter by class to focus your reorder-point tuning where it matters most.

Inventory turnover & dead stock

Two metrics that reveal whether your inventory is working for you or against you.

Inventory turnover ratio

How many times you sold and replaced the inventory in a period. Higher is generally better — capital isn't sitting idle on shelves.

Turnover = COGS / Average Inventory Value Days Inventory = 365 / Turnover

Benchmarks (roughly): grocery ≈ 15+; consumer electronics ≈ 5–8; general retail ≈ 4–6; specialty/luxury ≈ 2–4. Below 2 is generally a red flag — you're carrying too much stock for your sales rate.

Dead stock identification

SKUs with zero or near-zero ISSUE movements over an extended period. Cash frozen in a corner of the warehouse. Find them by counting ISSUEs per SKU over the last 90 days:

Dead Stock Flag = IF( COUNTIFS(MoveSKU, "X", MoveType, "ISSUE", MoveDate, ">="&TODAY()−90) = 0, "DEAD", "ACTIVE" )

Options for dead stock: discount / clearance sale, bundle with active products, return to supplier if consignment terms allow, or write off. Even a fire-sale recovers more than a shelf full of dust.

How to use the template in 5 steps

Zero setup — open the file, start on the Setup Guide sheet, and follow the flow.

1

Set up your Suppliers

Replace the 6 sample suppliers with yours. Each needs a SUP-ID, company name, category focus, contact, lead time (days), and payment terms.

2

Load your Product Master

Replace the 25 sample SKUs. Enter SKU, Name, Category, Unit Cost, Sell Price, Reorder Point, Reorder Qty, and Supplier (SUP-ID). Current Stock and Value auto-calculate.

3

Enter opening balances

On Stock Movements, log a RECEIVE for every SKU with its starting quantity — reference "OPEN-2026" and note "Opening balance." That's your baseline.

4

Track daily activity

One row per stock event. RECEIVE for POs and returns. ISSUE for sales and consumption. ADJUST for count corrections. Reference the PO or order number so you can audit later.

5

Act on the Reorder Report

Filter Reorder Report by Status = LOW or OUT. Suggested PO column shows how much to order, and Supplier tells you who to call. Generate this week's POs.

Customize it your way

Every formula and layout is open — nothing is protected. Six common edits.

Add a category

Edit the Category data-validation list on Product Master (Data ▸ Data Validation ▸ Source). Add the new category to the Dashboard's breakdown table with a matching row.

Track multiple warehouses

Add a "Location" column to Stock Movements. Update Product Master's Current Stock formula to add MoveLocation, "Warehouse-A" as an extra SUMIFS criterion. Duplicate for each location.

Add batch / lot tracking

Add a Lot Number column to Stock Movements. Use SUMIFS filtered on Lot to compute per-lot stock and support FIFO layer costing.

Compute inventory turnover

Add cells: Total COGS = SUMIFS(MoveValue,MoveType,"ISSUE"). Avg Inventory Value = (Opening + Closing) / 2. Turnover = COGS / Avg Inventory Value.

Add auto reorder qty via EOQ

Add an EOQ column on Product Master: =SQRT((2*AnnualDemand*OrderCost)/HoldingCost). Replace the manual Reorder Qty with the computed EOQ.

Grow the SKU catalog

Just add rows to Product Master. The Reorder Report and Dashboard reference the Product Master range — extend the ranges as needed. Named ranges on the Movements sheet already cover 300 rows.

Functions used in this template

Every formula here is documented on Sheets & Cells — click any function to open its deep-dive guide.

Stop guessing at stock levels.

Free download · Excel + Google Sheets + LibreOffice · No email · No account · No watermark.

Download .xlsx

Frequently asked questions

Fourteen questions covering setup, math, method, and troubleshooting.

Is this inventory template really free?

Yes. Free for personal and commercial use. Download the .xlsx, use it for as many SKUs and movements as you need, and modify it however you want. No email required, no watermark, no attribution needed.

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and open with Google Sheets. All 602 formulas convert cleanly because we intentionally use only Excel 2007-compatible functions (SUMIFS, COUNTIFS, VLOOKUP, IF, IFERROR, INDEX/MATCH) — no XLOOKUP, FILTER, or dynamic arrays that would break in older Excel or Sheets.

How does the auto Current Stock calculation work?

Each SKU's Current Stock is a formula: SUMIFS of all RECEIVE movements + SUMIFS of all ADJUST movements − SUMIFS of all ISSUE movements, filtered on that SKU. Change any movement (or add a new row) and every dashboard KPI, category total, and reorder alert updates automatically.

What's a good Reorder Point?

Formula: (Average Daily Usage × Supplier Lead Time) + Safety Stock. If a SKU sells 5 units/day, the supplier ships in 7 days, and you want a 10-unit cushion, ROP = 5×7 + 10 = 45. Set it too low and you'll stock out; too high and you tie up cash. Review quarterly as sales rates and lead times shift.

Can I use this for FIFO or LIFO costing?

Not natively — the template uses a single Unit Cost per SKU, which behaves like weighted-average valuation. For strict FIFO/LIFO you'd need to layer costs (track separate lots or receipts). Once you cross ~200 SKUs or your accountant demands proper cost layering, graduate to SOS Inventory, Cin7, or QuickBooks Enterprise Inventory.

How do I add more than 25 SKUs?

Just add rows to Product Master. The Category and Supplier dropdowns extend to row ~75 by default; if you need more, edit the data-validation Source range. The Reorder Report needs a matching row per SKU — copy an existing row and update the SKU cell; every formula uses VLOOKUP, so it auto-links.

Can I track multiple warehouses or locations?

Yes with a small edit. Add a "Location" column to Stock Movements. Then update the Current Stock formula on Product Master to add MoveLocation, "Warehouse-A" as an extra SUMIFS criterion. Duplicate the Product Master columns for each location, or add a Location dropdown filter at the top.

How do I handle damaged or lost inventory?

Log an ISSUE movement with quantity = units damaged, reference like "DMG-2026-05", and note describing the damage. The template ships with 2 sample damage write-offs (PACK-001 and SAFE-003). This keeps your audit trail clean and correctly reduces stock.

What's the difference between ISSUE and ADJUST?

ISSUE is for expected stock reductions — sales, fulfillment, internal consumption, damage. ADJUST is for corrections when a physical count doesn't match the log (positive: found more than expected). For a negative correction (count shows less than log says), use an ISSUE with note "count adjustment" — cleaner than trying to handle signed adjusts.

How often should I do a physical count?

Cycle counts, not annual: count a rotating subset every week or month. High-value A-class SKUs (per ABC analysis) should be counted monthly; medium B-class quarterly; low-value C-class semi-annually. A full wall-to-wall annual count is still needed for many auditors, but cycle counting catches discrepancies fast.

Can I generate purchase orders from this?

Not directly, but the Reorder Report gives you everything a PO needs: SKU, product name, suggested quantity, supplier. Filter by Status = LOW or OUT, copy those rows to your Purchase Order template (a separate download on Sheets & Cells), fill in your supplier's PO number, and email.

Why does a SKU show negative Current Stock?

Because more units were logged as ISSUE than as RECEIVE + ADJUST. This means either (a) an ISSUE was recorded for stock you didn't actually have — a data-entry error, or (b) a RECEIVE hasn't been logged yet. Filter the Stock Movements log to that SKU and reconcile against your PO paperwork.

Can I compute inventory turnover in this workbook?

Yes with a small addition. Add two cells anywhere: Total COGS = SUMIFS(MoveValue, MoveType, "ISSUE") — this is your period cost of goods sold. Average Inventory Value = (opening value + current value) / 2. Turnover ratio = COGS / Average Inventory Value. Multiply by 12 if you're working a monthly period to annualize.

Do I need Microsoft 365 to open this?

No. This template is built with Excel 2007+ compatibility, which means it opens in Excel 2007, 2010, 2013, 2016, 2019, 2021, 365, Excel for Mac, Excel Online, Google Sheets, and LibreOffice Calc. No subscription required.

Skip the manual formulas — try the AI Add-in

The Sheets & Cells Add-in generates reorder points from your movement history, flags dead stock automatically, and drafts PO emails to your suppliers — inside Excel, powered by Claude.

Get the AI Add-in →