Inventory Tracker Spreadsheet for Small Business | Stock Movement Log & Reorder Alert Excel Dashboard

Stop losing track of what you have, what you're out of, and what needs to be reordered before it's too late.

This is a complete inventory control system for small businesses — item master tracking, movement logging, reorder alerts, and a live dashboard — all in one file you download once and own forever.

No subscription. No login. No formulas to break. Open it in your browser and start tracking.

─────────────────────────────────
WHAT YOU GET
─────────────────────────────────
✅ 1 HTML file — opens instantly in Chrome, Safari, or Firefox, on Mac or PC
✅ 7 fully built tabs: Dashboard, Inventory, Movement Log, Reports, Setup, Guide, Customize
✅ Live dashboard with total inventory value, low stock alerts, reorder cost, and health score
✅ Item master with 21 fields: ID, name, category, location, vendor, SKU, cost, stock levels, and more
✅ Automatic Current Qty calculation — Opening + Stock In minus Stock Out, always up to date
✅ Automatic Inventory Value — Current Qty x Unit Cost, live on every row
✅ Reorder alerts that flag items the moment they fall below your minimum stock level
✅ Movement Log for Stock In, Stock Out, Returns, Transfers, and Adjustments
✅ Category breakdown showing value, reorder cost, and low-stock count per category
✅ Dark and light theme modes — switch with one click
✅ Customizable accent color — match your brand in seconds
✅ Everything auto-saves to your browser — nothing to upload, nothing to lose

─────────────────────────────────
7 TABS, FULLY BUILT
─────────────────────────────────
📊 DASHBOARD
Total inventory value, low stock count, out-of-stock count, estimated reorder cost, items tracked, and a health score — plus a value-by-category breakdown and a prioritized reorder alert list.

📦 INVENTORY
Your full item master — every item with its Item ID, name, category, location, vendor, SKU, unit cost, opening qty, stock in/out from the movement log, current qty (auto-calculated), min/max levels, inventory value (auto-calculated), status, and notes. Click any field to edit instantly.

📋 MOVEMENT LOG
Log every stock movement — Stock In, Stock Out, Return, Transfer, Adjustment + and Adjustment —. Select the item from a dropdown, enter the quantity, and the inventory tab updates automatically.

📈 REPORTS
Category-level inventory value, reorder cost, and low-stock counts — plus a movement summary showing entries and total units by movement type.

⚙️ SETUP
Customize your business name, review interval, categories, locations, vendors, movement types, and item statuses. Every dropdown across the tool pulls from here.

📖 GUIDE
Step-by-step instructions, key formula explanations, and tips — all inside the tool so you never need to read a manual.

🎨 CUSTOMIZE
Switch between dark and light mode with one click. Pick from 10 accent colors to match your brand.

─────────────────────────────────
HOW IT WORKS
─────────────────────────────────
1. Download the file instantly through Etsy
2. Double-click to open it in any browser
3. Enter your business name and customize categories in Setup
4. Add your items in the Inventory tab
5. Log every movement — stock in, stock out, returns — as they happen
6. Check your Dashboard for a real-time inventory snapshot

─────────────────────────────────
PERFECT FOR
─────────────────────────────────
→ Small business owners managing physical inventory
→ Retail shops, boutiques, and online sellers tracking stock
→ Warehouses and supply rooms needing a simple reorder system
→ Anyone replacing a messy spreadsheet with a real tracking tool
→ Freelancers and makers tracking materials and supplies

─────────────────────────────────
WHY THIS BEATS A SPREADSHEET
─────────────────────────────────
Spreadsheets break. Formulas get deleted the moment someone edits the wrong cell. This tool is built as an actual application — Current Qty, Inventory Value, and Reorder Alerts all recalculate automatically every time you log a movement. You click, you type, it's done.

─────────────────────────────────
COMPATIBILITY
─────────────────────────────────
Works in any modern browser — Chrome, Safari, Firefox, Edge. No installation, no account, no internet connection required after download. Compatible with Mac and PC.

─────────────────────────────────
AFTER PURCHASE
─────────────────────────────────
Your file delivers instantly through Etsy's automatic download system. Check "Purchases and Reviews" in your Etsy account right after checkout — no waiting, no email required.

─────────────────────────────────
QUESTIONS BEFORE YOU BUY?
─────────────────────────────────
Message us any time — we typically respond within 24 hours and are happy to help if anything doesn't open the way you expect.

─────────────────────────────────
PLEASE NOTE
─────────────────────────────────
This is a digital product — no physical item will ship. Because the file delivers instantly, we're unable to offer refunds once downloaded, but we will always work with you to fix any issue.