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.xlsxExcel 2007+ compatible · Also works in Google Sheets & LibreOffice
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.
| Category | SKUs | Stock | Value | % |
|---|---|---|---|---|
| Office | 6 | 1,128 | $4,926.00 | 30.7% |
| Packaging | 5 | 1,714 | $3,750.85 | 23.4% |
| Electronics | 6 | 365 | $3,196.65 | 19.9% |
| Safety | 4 | 277 | $2,116.70 | 13.2% |
| Cleaning | 4 | 417 | $2,073.00 | 12.9% |
| TOTAL | 25 | 3,901 | $14,244 | 100% |
| Type | Count | Value |
|---|---|---|
| RECEIVE | 36 | $21,337 |
| ISSUE | 36 | $5,306 |
| ADJUST | 1 | $32 |
| January | 73 | $26,675 |
| SKU | Product | Current | Reorder Pt | Status |
|---|---|---|---|---|
| ELEC-002 | Wireless Mouse | −6 | 20 | OUT |
| SAFE-004 | Safety Glasses Clear | −3 | 20 | OUT |
| SAFE-003 | First Aid Kit | 2 | 8 | LOW |
| OFFC-004 | Stapler Heavy Duty | 3 | 10 | LOW |
| PACK-001 | Bubble Wrap Roll 100ft | 14 | 20 | LOW |
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.
| SKU | Product | Cat | Cost | Price | Reorder Pt | Current | Value | Status |
|---|---|---|---|---|---|---|---|---|
| ELEC-001 | USB-C Cable 6ft | Electronics | $4.20 | $12.99 | 40 | 123 | $516.60 | OK |
| ELEC-002 | Wireless Mouse | Electronics | $11.50 | $29.99 | 20 | −6 | −$69.00 | OUT |
| OFFC-003 | Copy Paper A4 500sh | Office | $4.80 | $10.99 | 60 | 460 | $2,208.00 | OK |
| OFFC-004 | Stapler Heavy Duty | Office | $9.20 | $22.99 | 10 | 3 | $27.60 | LOW |
| PACK-001 | Bubble Wrap Roll 100ft | Packaging | $8.90 | $19.99 | 20 | 14 | $124.60 | LOW |
| SAFE-003 | First Aid Kit | Safety | $16.40 | $39.99 | 8 | 2 | $32.80 | LOW |
| … 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.
| Date | SKU | Type | Product | Qty | Value | Reference |
|---|---|---|---|---|---|---|
| Jan 1 | ELEC-001 | RECEIVE | USB-C Cable 6ft | 120 | $504.00 | OPEN-2026 |
| Jan 3 | ELEC-001 | ISSUE | USB-C Cable 6ft | 22 | $92.40 | ORD-9142 |
| Jan 5 | PACK-002 | RECEIVE | Shipping Box Medium | 500 | $425.00 | PO-2026-014 |
| Jan 8 | OFFC-003 | RECEIVE | Copy Paper A4 | 240 | $1,152.00 | PO-2026-016 |
| Jan 10 | OFFC-002 | ADJUST | Sticky Notes 3x3 | 5 | $32.00 | CNT-Q1-01 |
| Jan 13 | ELEC-006 | ISSUE | Bluetooth Speaker | 15 | $283.50 | ORD-9268 |
| Jan 17 | PACK-001 | ISSUE | Bubble Wrap Roll | 3 | $26.70 | DMG-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.
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.
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
| Type | Sign | When 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.
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:
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).
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 |
|---|---|---|---|
| FIFO | First In, First Out. Oldest inventory is sold first. | Lower COGS, higher profit, higher tax, higher ending inventory value. | Perishables, style-driven products, most retail. |
| LIFO | Last 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 Avg | Average 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.
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% valueMedium 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% valueLow 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% valueHow 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:
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.
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:
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.
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.
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.
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.
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.
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.
Stop guessing at stock levels.
Free download · Excel + Google Sheets + LibreOffice · No email · No account · No watermark.
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.
Related templates
More free downloads that pair well with the Inventory Tracker — most already live, a couple coming soon.
Expense Report
Vendor spend tracking
⏱Timesheet
Warehouse hours + OT
💰Budget Tracker
Category vs actual spend
📊KPI Dashboard
6-metric monthly view
🧾Purchase Order
Formalize reorder PO
📋Stock Count Sheet
Cycle-count worksheet
🧮Invoice Template
Bill customers for issued stock
📈Sales Dashboard
Rep performance vs quota
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 →